Hi Guys,
I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back .
I there any functionality available for this scenario
@143kishornaidu
Anaplan is best designed for pulling the data(aggregating the data) and you will have umpteen functionalities for the same.
but when it comes to disaggregation, i think break back is the best possible option for bringing the data for higher level to lower level.
there are some functionalities like PROFILE, SPREAD, which is helpful while doing calculations like depreciation etc. which basically pushes the data.Thanks,Manjunath
You can use LOOKUP function to cascade the numbers down from L2 to L3. Note that the numbers will be flat lined across all the children of the parent
Hope that helps
Misbah
Miz Logix
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
