Pivot - Advanced filter

S

sanshah01

Hi,

I have created a Pivot table for top 3 projects and their value for
each client within each country using Advanced options and "Autoshow"
option.

This works fine but I would also like to classify the other projects
(not within the top 3) as "Others" for each client so that the total
value per client is also visible within the pivot table.

Is this some how possible automatically through the pivot table or do I
mannually need to create some sort of ranking within the database which
can be quite time consuming.

Anyone's help on how to create the Pivot or any other solution is
appreciated.

Regards
Sandip.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
PIvot Table top Values 1
Splitting up data in a pivot table 1
making an excel table visible for external data on pivot table 1
Ranking within a pivot table 1
VBA: Pivot Cache Help 1
pivot table loosing decimals (vba) 1
Pivot Tables in Excel 2007 vs 2003 1

Top