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