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.
