Custom Headers for Pivot Table

[vikasmahajan]

Hi Team,

I have heading like this 

Sales$ YTD	Sales$ YTD	Sales$ YTD		Sales $ MAT	Sales $ MAT	Sales $ MAT
2020	2021	2022		2020	2021	2022

I wanted heading like this :

Sales$YTD -2020

Sales$YTD -2021

Sales$YTD -2022

Sales $ MAT-2020

Sales $ MAT-2021

Sales $ MAT-2022

I try  with Time_Period &'-'& Year  in heading but it is doubling the total is there any way to show heading in single line in Pivot table Qlik Sense.

Thanks in Adv

Vikas

[Mark_Little]

You would have to create multiple measures, One for Each the YTD headers.

[vikasmahajan]

Thanks for reply unfortunately I have 14 measures and 72 dimensions with 7 years of data  in this pivot is there any dynamic way to show in single line instead of 2 lines ?

Period Type	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales$ YTD	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT	Sales $ MAT
Year	2017	2018	2019	2020	2021	2022	Total	2017	2018	2019	2020	2021	2022

Thanks

Vikas