Pivot Table Filter Question

[Russ At Index]

Hi Everyone ,

I was wondering if anyone had a neat trick to help with my Monday morning dilemma ?.

My Pivot table has filter whereby i can see by individual or by group the results i would like to analyse .
Is these a way to just display the top 80 records , on pivot table filter function ?.

Any assistance would be great , although i fear this may not be "doable".

Regards ,

Russ.

 

[DanteAmor]

You mean this:

Excel Pivot Table Filters - Top 10

Use Excel Pivot Table Filters to focus on the top 10, bottom 10 or a specific portion of the total values in your data.

www.contextures.com