How to Create Previous year key figure Linked to Current year figure in Custom Analytical Query?

[Mayank_Gupta1]

Hi Everyone,

We have a requirement to Create Previous year which should be fetch automatically  from Current Year, while creating Query in Custom Analytical query app.

For example-

Suppose we are in fiscal year 2025, while fetching data from query user will input only current year, on the basis of which Previous year should automatically be fetched.

How can this be achieved through Custom analytical query.

Thanks and Regards,

Mayank Gupta