Column total in pivot table not summing properly

[#1]

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?

[sunny_talwar]

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))

[#3]

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

[sunny_talwar · Accepted solution]

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

[#5]

Yes - thank you very much!