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?
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?