how to calculate total cumulative sales in descending order

[PBI_newuser]

Hi, how to calculate the cumulative sales for total selected months in descending order by Country, Company and SKU? Below is the sample data.

https://drive.google.com/file/d/1QSxBcandDoIpdo4aA4uAkrIfpC0YNwSY/view?usp=sharing

For example, I select Jan to Dec 2023, the cumulative sales should calculate the total sales in descending order.

After calcuting the cumulative sales, I need to categorize the SKU in ABC category. The logic is as below:

• A: if cumulative % is <= 80%
• B: if cumulative % is <=90%
• C: if cumulative % is <=95%
• D : if cumulative % is <=100%
• else "Exited"

Expected output (in red):

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my solution file.

Hope this helps.

[PBI_newuser]

Hi @Ashish_Mathur , thanks for the solution! It works! 🙂

[Ashish_Mathur]

You are welcome.

[amitchandak]

@PBI_newuser , Refer if this can help

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4

[PBI_newuser]

Hi @amitchandak, I tried this solution but got below error.