Hi all,
I have the following table:

I need the variance calculation to change dynamically according to the date selection. The formula is Budget - Actual CY, but I need the difference between the year (Budget 2024 - Actual CY 2023), the quarter (Budget Q2 2024- Actual CY Q2 2023), the months (Budget Apr 2024 - Actual CY Apr 2023) and so on, in relation to my selection on the date member filter.
As you can see in the picture, the calculation is not working correctly. Do you know a way to allow this dynamic calculation with the date member filter ?
Thanks
Martina