Forum Discussion
Dynamic header names in Table visual
Hi there, I am working on a report wherein I would like to have dynamic header names on my Table visual. Pls see screenshot below for a sample report(prepared in excel). I need to display the mon...
Hi Ajay123,
So your requirement is to change the table column dynamically, right? I'm afraid dynamic table couldn't be achieved, however, as a workaround, you may follow steps below:
Click query editor-> click on columns Dec-18, Nov-18 and Oct-18 and click transform-> Unpivot Columns, the result is like below:
Then drag the three columns to Matrix visual like below and set visual level filter on column Date:
The result is like this:
Regards,
Jimmy Tao