Forum Discussion
Solved
Multiple filter in a pivot table to show the best "x" values using slicers
I have a pivot table with the following fields Row Fields Level 1 Level 2 Empl code Empl name Value Field Ranking By slicers, I make filt...
Slicers do not apply to Value Fields. If the Ranking is a number in the source data, then you can add a column where you calculate ranking groups with a formula such as ="Group " & INT(Ranking/10)+1. You would be able to create a slicer in the PivotTable if you have the ranking group in the source data.
Slicers do not apply to Value Fields. If the Ranking is a number in the source data, then you can add a column where you calculate ranking groups with a formula such as ="Group " & INT(Ranking/10)+1. You would be able to create a slicer in the PivotTable if you have the ranking group in the source data.