Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Column total in pivot table not summing properly

Hello,

I have built the pivot table in the screen shot attached (sample pivot table) and the column totals are not summing as I'd like them to.

The measure in the pivot table is [Total A]+[Total B] which are columns from two different excel sheets and where Total A and Total B are already sums of various other columns within the excel document. For example Total A = Sum(D5+E5) on Spreadsheet A and Total B =Sum(D5+E5) on Spreadsheet B.

Is there a way I can change the measure in the pivot table so that the top row "3B" displays a sum of the rows beneath it?

Tags (1)
1 Solution

Accepted Solutions

Re: Column total in pivot table not summing properly

Did you add your pivot table dimensions in the above Aggr() function?

4 Replies

Re: Column total in pivot table not summing properly

You can try with Sum(Aggr())... but this will require you to use the original expression instead of using the column labels

Sum(Aggr(Expression1 + Expression2, Dimension1, Dimension2, Date))

Not applicable

Re: Column total in pivot table not summing properly

That only worked for the first row in the pivot table, and set all the other rows to 0?

Re: Column total in pivot table not summing properly

Did you add your pivot table dimensions in the above Aggr() function?

Not applicable

Re: Column total in pivot table not summing properly

Yes - thank you very much!