Pivot table subtotals 100%
This is what I am aiming for but how can I get 100% in subtotals for first
year and the increase %age for the second and subsequent year please
2002 2003
Apples excellent 15 22.72% 16 24.23%
good 21 31.82% 25 37.88%
poor 30 46.46% 39 60.39%
66 100% 80 122.5%
Greens excellent 12 17.65% 37 54.42%
good 27 39.70% 51 74.98%
poor 29 42.65% 47 69.12%
68 100% 135 199.52%
|