Forum Discussion
Dynamic names in field parameters (Selectedvalue)
Hi community, I am trying to get dynamic column names in my tables in a way that it always shows the Gross revenue for the selected year and the year before. I am using a field parameter and I ...
Hi,
I have shown the sample output I would like to aquire.
I want gross revenue 2022, gross revenue 2021 if I select year = 2022
I want gross revenue 2021, gross revenue 2020 if I select year = 2021 etc.
I know the functions TODAY() and today - value works, but I want to do it on a selection based.