Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Dimension Based Custom Header for Partial Sum

Hi All,

I have created a pivot table with few dimensions  having QtrYear & Year part of it. Below is how i am getting now (CurrentTable) but expect is the second one. Please suggest how this can be achieved

 

CurrentTable:

 Year 20202021 
GL_Category_Description QuarterYear 2020-Q32020-Q4Total2021-Q3TotalTotal
Assets $100.00$250.00$350.00$100.00$100.00$450.00
Equity $100.00$300.00$400.00$100.00$100.00$500.00

 

ExpectedTable:

GL_Category_Description QuarterYear 2020-Q32020-Q4Total 20202021-Q3Total 2021Total
Assets $100.00$250.00$350.00$100.00$100.00$450.00
Equity $100.00$300.00$400.00$100.00$100.00$500.00

Thanks,

 

0 Replies