Display projection(based on previous year data) with dimension value of Previous year

[nitin_01]

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.

[Kushal_Chawda]

How year values are stored in table?

[nitin_01]

Fiscal Year

2019

2020

2021