Hi,
I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table.
I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns and it will showcase the values as 2017, 2018 & 2019. When i click 2019 in slicer the pivot get filtered to only 2019 and gives me the data in Dashboard view. Once i clear the entire filter 2019 is in expand view and 2017 & 2018 is been changed to collapsed view. Due to that in my dashboard 2017 & 2018 data is getting #REF error.
How to avoid pivot filter not to collapse column value.
I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table.
I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns and it will showcase the values as 2017, 2018 & 2019. When i click 2019 in slicer the pivot get filtered to only 2019 and gives me the data in Dashboard view. Once i clear the entire filter 2019 is in expand view and 2017 & 2018 is been changed to collapsed view. Due to that in my dashboard 2017 & 2018 data is getting #REF error.
How to avoid pivot filter not to collapse column value.
