Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner
Partner

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