Dynamic column names

Hi Community,

Is it possible to have dynamic column names in the table based on the value from Date filter (year from the date) ?
For example, when the user picks date 11-08-2022 the column names should be:
Column 2022, Column 2023, Column 2024, Column 2025 and Column 2026.

Hi Jelena ,
Based on you what you explained here , you can create a calculated field such as
Column - Year = concat('Column ’ , toString(Year))

And what you select on data , values can be passed through parameter and filter for last 3 years ( in this example I have sales data for 2021 and 2018 and showing last 3 years in table)
Your column on pivot table can be rendered dynamically based on year in selected date.

  • pDate is parameter used

This is how it would be achieved , Hope this helps your use-case

Use-case1 (2)