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

Doughnut Chart linked with the slicer in the pivot table 0
Pivot - top 10 stocks & missing info 1
Top 5 plus Other in Pivot table 1
Creating multiple pivot table report at run time 0
Pivot - Calculated field in row area 3
top 10 0
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
List top five results based on age grouping 2

Top