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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super 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.

Migsmix's avatar
Migsmix
Frequent Visitor
4 years ago

Hello Ashish_Mathur , it should be sorted ascended by sales past 12 months.

 

Thanks!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • Migsmix's avatar
      Migsmix
      Frequent Visitor
      4 years ago

      Thank you Ashish_Mathur . If i want to filter by zone so the table shows me the cumulative sales only of the products in the zone "start", how can i do that? 

       

      thanks!!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.