In reply to Daniel.

Hi Daniel,

Unfortunately, you cannot dynamically assign column Roles, yet.

You can, however, use a different report design to meet this requirement. I've shown an example below, using the List Control Object in the report canvas, but you can place the List Control Object in either the Report or Page Prompt areas.

As you can see in the screenshot below, first you add the List Control Object to the report. I created a column that is similar to what you used in your comment. Second, add the Objects to the report and assign Roles. Third, you want to define a Filter Action to any desired report Objects.

Screenshot 1

Note: if you place the List Control Object in either the Report or Page Prompt area then you will not need to complete step three as the Filter Action is automatically applied.

Here are some other screenshots to highlight the advantages of using this type of report design. In this screenshot, I’ve selected the two most recent quarters in the data.

Screenshot 2

And in this last screenshot, I’ve selected all the fourth quarters in the data for comparison.

Screenshot 3

I’m happy to discuss other report design options, just let me know and I can reach out offline.
Thank you,
Teri