|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 5th, 2010, 08:31 AM
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
May 5th, 2010, 08:59 AM
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
May 5th, 2010, 10:53 AM
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
May 5th, 2010, 07:03 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
