Parent Column Name in Pivot table

rohitk1609 — Sat, 16 Nov 2024 09:00:31 GMT

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

B
C

My requirement is :

Measures

MTD YTD

Cal1,Cal2 Cal3 Cal4 Cal5

Brand

B
C

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

topic Parent Column Name in Pivot table in App Development