Dropdown for Preset Filters in Pivot

[Bim1]

I have a pivot table where i would like to filter the values according to top 10, bottom 10 etc. I know that it works with using the filters in the pivot tables (Value Filters - Top 10 ...), but for making it easier and faster to use these filters, I would like to have some preset filter options as buttons or a drop down menu that immediately display them. so that you don't need to choose the filter values yourself. I need to be able to either filter the e.g. Top2 Business Areas or within one Business Area filter the top 3 Business Groups. I thought about maybe making a drop down menu where you can choose the business areas and then another drop down where you can choose the Filter such as Top10, Bottom 10, Top 3 etc. Does someone have a clue of how to do this?

thx
bSample_Pivot.xlsx

[nathansav]

Record macros doing it through the filters, this will then give you the code to attach to a button.

[Bim1]

thx a lot! that should work.

[nathansav]

no probs, glad to help