Pareto Analysis

Options
mikeng
mikeng Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

Currently I am doing Pareto Analysis to identify top 80% of the Sku (S3) at Department level (B5) and at SKU Group (S1).

The result expectation is like last 3 columns (F to H)

mikeng_0-1600913153193.png

Note: The Sum(1791) is the total of Sku at group for the year.

 

Please assist your ideas to achieve this in Anaplan. 

Tagged:

Comments

  • mikeng
    mikeng Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    Hi @anirudh  Thankyou for your time to look into this. Actually I have already tried the solution given by you but it is not giving the result as expected. 

     

    Here is the snapshot of my module blueprint:

    mikeng_0-1600923793105.png

     

    The underlying problem is that i need to consider previous SKU to cumulate the quantity and that too in seqence.

     

     

Categories