cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ajay123 Regular Visitor
Regular Visitor

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 month name for current and previous 2 months in the header.

 

The first table (Sales data as on 31-Dec-2018) gives the Sales for December, November & October and the second table (Sales data as on 30-Nov-2018) gives the Sales for November, October and September.

 

Dynamic_Header.PNG

 

 Kindly suggest as to how to achieve this.

 

Thanks in advance,

Ajay

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamic header names in Table visual

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:

Capture.PNG 

 

Then drag the three columns to Matrix visual like below and set visual level filter on column Date:

1.PNG2.PNG 

 

The result is like this:

Capture.PNG 

 

Regards,

Jimmy Tao