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"