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 filters for the fields Level 1 and Level 2. I need to get the best x (e.g. the top 10) from the filtered lists based on the value of the Ranking field. don't know if it can be done with slicer, although it would also be useful to group the ranking by brackets (for example 1-10, 11-20....) and create a slicer with these brackets to filter the list.
Thnks in advance.
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.
3 Replies
Hi Kidd_Ip
Thanks for your help and your time.
I have seen the link you left me but I don't see a way to select the best x from the table.
May i have lost something?
Regards
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.
