3 Replies Latest reply on Jan 15, 2017 11:55 AM by Norbert Maijoor

    Percent of Total  and Total Average % of Total

    gloria salazar

      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.

       

      TC help.png