Dynamic Headers

Question & Answer
, ,
1

I’m trying to make dynamic the headers of a table based on the previous month and year of a given date.

I found this solution: Dynamic column names - #2 by Neeraj

My problem is that it relies on a parameter, which, in turn, is selected by the user as a date from a filter, whereas my date comes from the selection of the month and the year (I attach the image).

I know I can obtain the the previous month and the previous year through a Calculated Field, however, parameters cannot be set up by calculated fields, so I’m running out of ideas. Do you have any piece of advice for me?

image

2

Hi @sarairg ,

I can only think of a workaround. Using custom narrative create the title you want and overlay it in place of the Visual Title.