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