Pivot table: filter values great then, lower then...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So far I can only fitler TOP X pr BOTTOM X items of the pivot table, but I
would need to filter items i.e. greater then certain amount. Can this be done?
 
Nope Top X or Bottom X. To do what you want you will need to add a helper
column to tyour source data which serves to flag the items you want...
 
Thanks.

Jim Thomlinson said:
Nope Top X or Bottom X. To do what you want you will need to add a helper
column to tyour source data which serves to flag the items you want...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table bottom ten filter with conditions 2
Top X% in Pivot Tables 1
pivot table filter 6
Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table Filter Formula 1
XL2007 - Pivot Table Limitations 2
date filter in a pivot table 1
Pivot table, IF function, calculated item versus calculated field 1

Back
Top