I have a pivot table that I am currently showing three parent fields, then the top ten customers for each parent in the rows. Sales dollars are in columns.
My goal is to show a % of total parent sales, but the % should be calculated on the full parent value, not just the top ten total that are in the filtered view. Currently, I have a side calculation in the column to the right referencing a separate pivot table that is summing parent sales from the original dataset.
Is there any way to get this % of total parent sales into the pivot table, or do I have to live with the side calculation?
Thanks.
Using MS365, Excel Version 2307
Bookmarks