About MathisG

Hello,   You can use the rankcumulate function : https://help.anaplan.com/4727e9c5-4687-45ec-a4a0-420d30476d42-RANKCUMULATE   Create one "priority" line item per child and one "need" line item per child, and use it for your rankcumulate :    Child 1 Child 2 Child 3 Priority 1 2 3 Need 60 50 40 Rankcumulate 60 110 150 allocation (50) 50 0 0 allocation (120) 60 50 10   Thanks to that, you will be able to have the allocation with a formula like MIN(Need, MAX(TotalStaff - Rankcumulate + Need,0))   I hope this is what you wanted to do ... View more

Hello,   What you can do is put a conditional formatting on the finest levels (or vice versa) on all your line items I hope this helps ... View more

Hello Sivasankar,   It is actually not possible to manage this just with selective acces, simply because the summary "Region B" can not have one value for a user and another for another one.   If you really really need to do that, you can dimension new line items with the same dimensions + the user list and create a rule "if user has access then value else 0". Each user will see the correct totals, but this will greatly increase the size of your model and the complexity.   Regards ... View more