Hi,
Can I make a "calculated row" in a pivot table? I want to combine two rows with a calculation. IE, the CH-APPLE row below which would be the Apple row plus 1/2 of the Cherry Row.
Thanks!,
Alex
My Raw Data Table looks like so:
Can I make a "calculated row" in a pivot table? I want to combine two rows with a calculation. IE, the CH-APPLE row below which would be the Apple row plus 1/2 of the Cherry Row.
Thanks!,
Alex
| (Pivot Table) | Month | |
| Fruit | Jan | Feb |
| Apple | 1 | 2 |
| Banana | 3 | |
| Cherry | 4 | 10 |
| CH-APPLE | 3 | 7 |
My Raw Data Table looks like so:
| Fruit | Month | Amount |
| Apple | Jan | 1 |
| Apple | Feb | 2 |
| Banana | Jan | 3 |
| Cherry | Jan | 4 |
| Cherry | Feb | 10 |
. (Thanks a lot Rory)
