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.
