Prev: About Data Validation
Next: Excel 2007 Pivot Tables compatible with 2003
From: Kenneth Andersen on 5 May 2010 03:31
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
From: ozgrid.com on 5 May 2010 03:59
Use 2 PivotTables and base the 2nd of the first.



--
Regards
Dave Hawley
www.ozgrid.com
"Kenneth Andersen" <KennethAndersen(a)discussions.microsoft.com> wrote in
message news:A8F44EE3-9259-4B2B-97C3-AA58992F1893(a)microsoft.com...
> 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

From: Kenneth Andersen on 5 May 2010 05:53
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
From: Herbert Seidenberg on 5 May 2010 14:03
Excel 2007 PivotTable
Top 10, Others
Dave's idea expounded.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_05_10.xlsx
Pdf preview:
http://www.mediafire.com/file/nytzxwwzyct/05_05_10.pdf
 | 
Pages: 1
Prev: About Data Validation
Next: Excel 2007 Pivot Tables compatible with 2003