Hi experts,
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:
| Supplier | Part | Quantity |
| S1 | P1 | 10 |
| S2 | P2 | 20 |
| S3 | P3 | 30 |
F-21 Data as per Transaction:
| Supplier | Part | Quantity |
| S1 | P1 | 5 |
| S2 | P2 | 5 |
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.
| Supplier | Part | Quantity |
| S1 | P1 | 7.5 |
| S2 | P2 | 15 |
| S3 | P3 | 22.5 |
@sunny_talwar
Regards,
Nitin.
