Pivot Tables - Top 10 hide negatives values

C

Cinny

Hi

I have created a Pivot table which has filtered customer data based on their
growth from LY, Top 10 and Bottom 10. Becasue one category of customer >250
only has 10 customers and all of them are growing negatively this year on
last year I would expect that they would not appear in the TOP 10, however
because they are the only customers in this category it seems the pivot table
wants them there. Is there anyway I can ask for a TOP 10 and have a
condition saying do not show if has a negative growth?
 

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

Top X% in Pivot Tables 1
Problem - Show values as % of Grand total 0
Top 10 with Repeated Values 9
Top N Pivot Anomaly 0
pivot table - shows zero when should not be 1
Hide Intermediate Levels in Date Dimension 0
Duplicating Pivot Tables 2
PIvot Table top Values 1

Top