| 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) | |||
Hybrid Mode
