Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
partial sum solved it.
partial sum solved it.