I have a Pivot table of products in rows and Sales, COGS & Margin in columns.
I have filtered the Pivot Table to show only To 10 Items based on highest sales in Descending Order.
Now I want to show for each product what is the percentage of its sales compared to Sales of all Products.
When I select show value as % Grand Total or Column Total it will not reflect the proper number as its basing on the totals of Filtered Top items only.
How do I change it to show the % based in the sales of all Products ?
Bookmarks