Top X% in Pivot Tables

B

BernieG

I created a Pivot Table and want to display only the Top 20% of Customers.

I go to the Pivot Table Field List and open the filtering drop-down list for
a field. Then I select "Value Filters". But the only filtering option
available is "Top 10"; all other filtering options are grayed out. If I want
to filter by a certain range of values, I can't.

Then, when I select "Top 10", I can only filter by Item; Percent and Sum
don't appear in the drop-down list. Any ideas?
 
B

BernieG

I've discovered the answer to my own question. I was working with an Excel
1997/2003 file. I had to save it as an Excel 2007 file to use those features.
 

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

Grouping Dates in Excel 2007 Pivot Tables 1
Are Date filters available for items in the Filter area of pivot t 2
pivot tables 4
pivot tables 1
Sort top 50 in Pivot table 2
Pivot Table Drop Downs 3
date filter in a pivot table 1
Single Filter to change all Pivot Tables in a Workbook 8

Top