Dear Friends,
I have a pivot table like this:
QUALITY POINTS
ITEM COMPANY A1 A2 B1 B2 C1 C2 D1 D2 TOTAL
HANDYCAM A 12 4 2 2 2 22
B 3 5 9 4 3 9 3 1 37
C 11 3 4 2 1 21
D 13 9 2 4 1 2 3 5 39
I need to insert a row alternatively to do a percentage calculation of each quality points, as like below:
QUALITY POINTS
ITEM COMPANY A1 A2 B1 B2 C1 C2 D1 D2 TOTAL
HANDYCAM A 12 4 2 2 0 2 0 0 22
54.55 18.18 9.09 9.09 0.00 9.09 0.00 0.00 100.00
B 3 5 9 4 3 9 3 1 37
8.11 13.51 24.32 10.81 8.11 24.32 8.11 2.70 100.00
C 11 3 4 2 0 1 0 0 21
52.38 14.29 19.05 9.52 0.00 4.76 0.00 0.00 100.00
D 13 9 2 4 1 2 3 5 39
33.33 23.08 5.13 10.26 2.56 5.13 7.69 12.82 100.00
Is it possible to do like this in pivot table? If NO, any alternate method to accomplish this target? The items / company columns in my table frequently varies. Hence I am unable to refer the pivot table cells in any other sheet.
Any help is highly appreciated.
Thanks in advance.
acsishere.
Bookmarks