pivot table total

[#1]

Hi all,

I have a pivot table as follows:

unit	A	B	C	D	E
expression1	3	1	4	4	4
expression2	2	5	2	2	2
expression3	0	8	1	2	2

where a - e are each units. Each expression uses an aggr function so I can calculate the total per each unit. I would like an additional column which gives the sum of a,b,c,d,e for each expression (1,2,3). this seems very easy using a straight table but i can't seem to find how to achieve this for a pivot table. Anyone any ideas?

Typically, my table would therefore look this this at completion:

unit	A	B	C	D	E	Sum
expression1	3	1	4	4	4	16
expression2	2	5	2	2	2	13
expression3	0	8	1	2	2	13

I thought sum(expression1) would work but I get an extra row with null values instead of an extra column. I have read similar threads but it doesn;t seem to work for me.

Help would be appreciated.

[#2 · Accepted solution]

partial sum solved it.