Top 10 in pivot - show rest as other or similar
 

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

Top 10 in pivot - show rest as other or similar
 

Use 2 PivotTables and base the 2nd of the first.



--
Regards
Dave Hawley
www.ozgrid.com
"Kenneth Andersen" wrote in
message ...
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

Top 10 in pivot - show rest as other or similar
 

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

Top 10 in pivot - show rest as other or similar
 

Excel 2007 PivotTable
Top 10, Others
Dave's idea expounded.
http://c0718892.cdn.cloudfiles.racks.../05_05_10.xlsx
Pdf preview:
http://www.mediafire.com/file/nytzxwwzyct/05_05_10.pdf