Dear All
I have a pivot table that does some basic calculations using a few expressions. What I am calculating is usually just the sum in each case and I show the subtotals. One of my dimensions is year and the purpose of the table is to compare year on year. What I want to do is to show the percentage change between years for each of the expressions (e.g. like a subtotal calculation in each column of the table) - does anyone know how I might do it?
| Dept | Year | Total | Status 1 | Status 2 | Status 3 | Status 4 |
|---|
| | 16809 | 9204 | 1210 | 80 | 225 |
| Dept 1 | 201516 | 6223 | 3378 | 556 | 32 | 82 |
| Dept 1 | 201415 | 4736 | 2419 | 427 | 37 | 34 |
| Dept 1 | 201314 | 3919 | 3800 | 186 | 35 | 35 |
| Dept 2 | 201516 | 639 | 431 | 14 | 7 | 3 |
| Dept 2 | 201415 | 919 | 980 | 21 | 2 | 1 |
| Dept 2 | 201314 | 363 | 335 | 5 | 0 | 1 |
These are not the real figures....
I want to then be able to have for the total and for each status a row at the bottom that show % change between 201516 and 201415 and then another that shows percentage change between 201415 and 201314.
Does anyone have any suggestions?
Thanks
Alison
