I have a pivot table that can vary in size. It lists sales by week (rows),for each sales team (columns) with a subtotal of the total sales year to date for each team at the bottom.
I want to keep the actual number subtotal visable but ALSO want to show what % of the total sales each team accounts for. This is very easy as a standard formula however the length of the pivot table varies as I change the product groups.
Any ideas how to display both actual sums and % of totals?
I want to keep the actual number subtotal visable but ALSO want to show what % of the total sales each team accounts for. This is very easy as a standard formula however the length of the pivot table varies as I change the product groups.
Any ideas how to display both actual sums and % of totals?