G
Guest
How can I get a pivot table with 100% in subtotal and increase the %age yearly?
2002 2003
Produce Grading No. % of Produce No. % of Produce
Apples excellent 10 23.26% 14 32.56%
good 20 46.51% 22 51.16%
poor 13 30.24% 9 20.93%
Apples Total 43 100.00% 45 104.65%
Greens excellent 15 9.09% 22 13.33%
good 60 36.36% 58 35.15%
poor 90 54.54% 81 85.15%
Greens Total 165 100.00% 171 103.64%
Potatoes excellent 6 4.26% 8 5.67%
good 45 31.91% 51 36.17%
poor 90 63.83% 73 48.22%
Potatoes Total 141 100.00% 127 90.07%
2002 2003
Produce Grading No. % of Produce No. % of Produce
Apples excellent 10 23.26% 14 32.56%
good 20 46.51% 22 51.16%
poor 13 30.24% 9 20.93%
Apples Total 43 100.00% 45 104.65%
Greens excellent 15 9.09% 22 13.33%
good 60 36.36% 58 35.15%
poor 90 54.54% 81 85.15%
Greens Total 165 100.00% 171 103.64%
Potatoes excellent 6 4.26% 8 5.67%
good 45 31.91% 51 36.17%
poor 90 63.83% 73 48.22%
Potatoes Total 141 100.00% 127 90.07%