Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables: Don't show data for detail, but still show subtotals | Excel Worksheet Functions | |||
can Excel show display bookmarks similar to Acrobat | Excel Discussion (Misc queries) | |||
Single Pivot table for similar Multiple sheets? | Excel Discussion (Misc queries) | |||
creating pivot table with similar columnames | Excel Discussion (Misc queries) | |||
Pivot Table or something similar | Excel Discussion (Misc queries) |