Define Multi Dimensional Level Payout grid
I have a scenario where i have to calculate the commission based on multi level payout grid.
Input : End user will be able to define payout grid at any level of dimension by month on month , based on that particular month payout structure.
Ex : April month Applicability of Payout at 2 level of list i.e A,B. Assuming Each List have two children - A -> A1,A2 , B -> B1,B2.
April Month Payout grid :
|50K -1 Lakhs||15.00%||15.00%||15.00%||15.00%|
Data and Calculation
For may month , C list can be added in payout grid , so accordingly need to define payout grid.
how can we resolve this problem in anaplan , to provide multilevel dimensional module to capture the payout % by month on month.