I have created a Pivot table for top 3 projects and their value for
each client within each country using Advanced options and "Autoshow"
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