Forum Discussion

Migsmix's avatar
Migsmix
Frequent Visitor
4 years ago
Solved

Cumulative total sales %

Hi!

 

I'm struggling calculating the cumulative sales % for my products. Basically i want to do a pareto analysis so i know the number of products that give me the 80% of my sales. In the attached file you can see the table and how should it look. In this example, 13 of my products make the 80% of my past 12 months sales. Also, i should be able to filter by zone, brand, type, etc and show me how many products make the 80% of my sales. 

 

Thanks! Here is the attached file. 

Need Help

7 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    Migsmix 

    is this what you want?

    Measure = sumx(FILTER(all('Table'),'Table'[Content]<=max('Table'[Content])),'Table'[Sales Past 12 months])

Measure 2 = [Measure]/CALCULATE(sum('Table'[Sales Past 12 months]),all('Table'))

    pls see the attachment below

    • Migsmix's avatar
      Migsmix
      Frequent Visitor
      4 years ago

      Hello ryan_mayu , the table should be sorted ascendent by sales past 12 months. Also, if i use a filter like brand, type or zone, the table should be recalculated to show those products that make de 80% of the sales in the brand "Font" or Zone "Final". With this i can see the number of products that make de 80% of the past 12 sales and also see the which products are.

       

      Thanks!

       

      Thanks!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    On what basis have you decided the order in which the rows have to be sorted?  Do they have to be sorted by the Content column in ascending order?  This is important to know because the numbers in the Cumulative column will depend on that.