Year Dimension - 2018
Accounting Period Dimension - Jan-18, Feb-18, Mar-18, Apr-18 ........Dec-18
Customer Requirements - Row Calculation based on POV - Accounting Period
Column: Current Month and Previous Month
Ratio Analysis Average Calculation for Current Month(For E.g. POV Accounting Period -Mar-18 is 3rd Month)
= ([4,A]+[12,A])* 3/12
Ratio Analysis Average Calculation for Previous Month(For E.g. POV Accounting Period -Feb-18 is 2rd Month)
= ([4,A]+[12,A])* 2/12
Please help on above queries how to achieve dynamically POV Accounting Period calculation Mar-18 to 3 and Feb-18 to 2 in this case.