NoHandJohn
New Member
- Joined
- Jan 30, 2019
- Messages
- 4
I would like to add a column to show the percentage change from 2017 to 2018. I would like to keep the current 2017 and 2018 data as is, and just add one column to the right if possible. When I just add it beside the pivot table the percentages dont follow when I expand/collapse the row data.
<tbody>
</tbody>
Sum of Net | Column Labels | |
Row Labels | 2017 | 2018 |
Sm/Med | 9596 | 9450 |
L/XL | 6999 | 5190 |
Proposal Other | -10 | -1 |
Rebated | 6601 | 6822 |
direct | 958 | 651 |
project rebate | 2489 | 2561 |
stock | 5114 | 5406 |
Grand Total | 31747 | 30079 |
<tbody>
</tbody>