Hi everyone... I come from the old BEx development background and now find myself in the SAP Custom Analytical Query area. I have been building requirement documents rather than doing the actual report/query development the past several years. I have been asked to help out some developers to do some of the Current vs Prior Year build.
I am looking for some quick help to build Calculated Key Figures for Current Year/CY and Prior Year/PY revenues based on one input for Fiscal Year. Basically CY would be revenue as at [Fiscal Year] = 2023. PY would be revenue as at [Fiscal Year]-1 = 2022.
Just need some quick input on how to do this.
Thank you.
Lou