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.

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.