Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
poojask123
Partner - Creator
Partner - Creator

Multiple expression sub total in Pivot table

Hi,

I have a pivot table with 4 dimensions and 2 expressions. 2 of the dimensions are pivoted and are along the columns. The table looks like below. The cells highlighted in green is the MainCategory and the one's below are the sub Category.

Capture_now.PNG

Columns C & D is a partial sum at the MainCategory level, which is set in the presentation tab.

I want to add totals to this table where the total = (Current AY + Prior AY) for every MainCategory. The table should look like below:

Capture-after.PNG

Any help is appreciated.

Thanks

1 Reply
sunny_talwar

This may not be available directly, but there are work around you can use to make this possible.... would you be able to provide sample data to show how this can be done?