Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Master
Master

Parent Column Name in Pivot table

Hi Techies,

I have a pivot table which has one dimension and 5 calculated measure which has label with variables. The pivot look like:

                   Measures

Brand  Cal1,Cal2 Cal3 Cal4 Cal5

A

B
C

D

My requirement is :

                   Measures

               MTD               YTD

           Cal1,Cal2 Cal3 Cal4 Cal5

Brand 

A

B
C

D

I want to put MTD for Cal1 and Cal2 then YTD for Cal3, Cal4, Cal5.

Please guide me how to do it, Do i need to add one more dimension with MTD and YTD values or something else ?

Best

Rohit

Labels (1)
0 Replies