Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an KPI showing sum of Current Fiscal Year Sales .
Fiscal year column have data for FY 2021, FY2020 , FY2019 etc
For KPI I want Sum(Sales) for FY 2019.
I have created a variable
LET vCnFY = PEEK('Fiscal Year', 0 ,'Calendar');
and vCnFY gives me 2019 and KPI shows correct data .
But if I select FY2018 KPI still shows for FY2019. So KPI is not changing with filter selection
KPI expression looks like this : Sum({$<[Fiscal Year ]={'$(vCnFY )'}>}Sales)
I cannot use Max function because it will show me FY2021 data in KPI.
>>I cannot use Max function because it will show me FY2021 data in KPI.
Not true. If you select FY2018, then the max, if defined correctly, will be 2018.