This content has been marked as final. Show 3 replies
I need to calculate the percent of total for each year (10 years) across each sub-cat and then take the average of each %of total for each category. Image below does a better job at explaining it.
My goal is to create 5 charts for each Sub-Category showing the Average % of Total for each department for Cat-1 and Cat-2.
Attached is my package workbook ; any help is much appreciated.