Display projection(based on previous year data) with dimension value of Previous year
I am calculating projection for F-21 based on data of F-20, have achieved the projection as per requirement and displayed same in KPI Object,but i am facing issue while displaying data at granular level in straight table. Below is the requirement.
Projection formula :
Current FY Quantity = 75% of Previous FY Quantity
F-20 Data as per Transaction:
F-21 Data as per Transaction:
Though i have few transaction in FY 21, i need to display Projected Quantity against the previous year record and display same after FY- 21 selection.
Desired Output after Selection of FY-21 in straight table.