7 Replies Latest reply on Jun 3, 2016 11:23 AM by msa s

    How to get percentage of total by week?

    jenn.ng

      I have sale counts of flowers and fruits sold each day and can be aggregated over weeks. I'm interested to know how to get percentage of flowers vs fruits sold each week and for each week, the percentages should sum up to 100%. I think the difficult part is how my columns are structured. Rose and mango are subsets of flower and fruit sold respectively but we can ignore it for now.

       

      Here is my data:

       

      Screen Shot 2016-06-03 at 3.02.00 AM.png

       

      my workbook: (i have measure names filtered to include only 'flower' and 'fruit')

      currently it is sum but i want percentage by column where y axis should be 100%. i tried Analysis > get percentage by column but i get equal distributed color parts instead.

      Screen Shot 2016-06-03 at 3.03.34 AM.png

       

      workbook attached.