Top 10 in pivot - show rest as other or similar

  • Thread starter Kenneth Andersen
  • Start date
K

Kenneth Andersen

Hi

I need to create a pivot table .... it could be revenue per. country. Let us
assume that there are 30 countries. I only want to display top 10. I can find
out of it so far, but I would like the remaining countries also shown,
however, together as an "other" or similar.

Can this ever be done. I use Excel 2007.

Kind regards, Kenneth
 
K

Kenneth Andersen

I don't know what you mean. I would like a pivot showing top 10 + other.
Example:
Germany 1000
England 900
Spain 875
Italy 850
Etc
Etc
Other 1.125
 

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 5 plus Other in Pivot table 1
Pivot - top 10 stocks & missing info 2
Samoa Air says charging passengers by weight is 'concept of the future' 5
PIvot Table top Values 1
Pivot - Calculated field in row area 3
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Need Help Using Calculated Field or Item in Pivot Table 1
filter data by top 10 AND bottom 10 items simultaneously 4

Top