Pareto Analysis

mikeng
mikeng
in 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:

Answers

  • anirudh
    anirudh
    Hi mikeng

    I'm assuming you have the data in Anaplan looking exactly like it is in the screenshot
    1. For the Ranking column, use the RANK formula
    2. For the Accum. column use this formula:
    "CUMULATE(Quantity, <Name of SKU List>)"
    3. Create another module without the SKU dimension but otherwise set up like the first module; just one line item with the formula: "Quantity" This will get the 1791 at the top level for each other dimension
    4. Then the formula for Pareto will be:
    "Accum./Quantity at top level"

    Let me know if you need more help

    Regards,
    Anirudh
  • mikeng
    mikeng

    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.

     

     

  • nathan_rudman
    nathan_rudman

    not clear what you mean by previous SKU but I think the right formula is RANKCUMULATE as cumulate only cumulate in the order of the list, not the ranking you provide

Categories