Using Parameters in Headers

Daniel.Hut

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!

JohnW-Oracle

Hi @Daniel.Hut,

Would it be possible to upload a screenshot of the issue and the calculation without showing any PI?

Thanks,

John

Daniel.Hut

Daniel.Hut

@JohnW-Oracle Uploaded the screenshot. Within the same table the values for YTD, Full year. etc are included therefore I cannot use a field like "fiscal Period"