Hello,
I have a question but im not sure if it can be done.
I have attached a sample sheet for reference.
In Sheet 1 i have the data and in sheet 2 I have a pivot chart.
In the pivot chart i want the "sum of cost" to have the % of "sum of sales" and also the "sum of savings" to have the % of "sum of cost"
I know i could probably write them in but the data will be chainging and i want the percentages to be interactive with my changing data.
Also for the "sum of cost" (not in the current data) there are 2 different categories of costs and I was wondering if i could somehow have the red bar 2 different colors showing the % of the bar are those 2 different categories of cost.
Thanks.
Bookmarks