We created a Financial Table Overview (P&L). Displaying the costs of the last 3 months, YTD figures, FY figures and prev year figure extrapolation etc.
For period filtering, we created a custom parameter for " period end selection" . We also used this parameter within the header of the actual costs column displaying the current period costs.
Actuals @parameter("Year") - @parameter("Period Selection End") = for example 2024-12
This works as expected, but we are now struggling on how we can use a similar logic for the 2 periods before 2024-12. So displaying 2024-11 & 2024-10 in the header. Calculation within the "Display Header" Field do not work. Is there a way to display the correct header for the 2 previous periods.
All help is much appreciated!
