Excel透视表

herb123

怎样在透视表中显示candy占Canada Total的百分比? [em00] Week 11 Busniess (All) LOB (All) Sales Rep (All) Data Manager Payment_method Rev. #of method Rev. mix Method mix Annie Zou Credit Card $37,575 52 1.12% 1.42% POD $1,259 2 0.04% 0.05% Prepaid $121,173 195 3.60% 5.32% Annie Zou Total $160,007 249 4.75% 6.79% Belinda Ma Credit Card $47,681 66 1.42% 1.80% Lease $6,929 9 0.21% 0.25% POD $4,770 8 0.14% 0.22% Prepaid $160,163 222 4.76% 6.06% Belinda Ma Total $219,543 305 6.52% 8.32% Charles Zhan Credit Card $4,688 5 0.14% 0.14% Prepaid $425,895 378 12.65% 10.31% Terms $969 1 0.03% 0.03% Charles Zhan Total $431,552 384 12.82% 10.48% Cohen Yang Credit Card $17,942 13 0.53% 0.35% Prepaid $520,008 417 15.45% 11.38% Terms $3,362 5 0.10% 0.14% Cohen Yang Total $541,313 435 16.08% 11.87% Dasiy Huang Credit Card $335,293 353 9.96% 9.63% Lease $27,732 23 0.82% 0.63% Prepaid $156,738 139 4.66% 3.79% Terms $30,982 16 0.92% 0.44% Dasiy Huang Total $550,745 531 16.36% 14.49% Helena Guo Credit Card $20,561 33 0.61% 0.90% Lease $3,152 5 0.09% 0.14% POD $2,352 3 0.07% 0.08% Prepaid $113,487 181 3.37% 4.94% Helena Guo Total $139,552 222 4.15% 6.06% Jane Peng Credit Card $34,952 62 1.04% 1.69% Lease $17,084 15 0.51% 0.41% POD $2,800 4 0.08% 0.11% Prepaid $144,305 211 4.29% 5.76% Terms $762 1 0.02% 0.03% Jane Peng Total $199,902 293 5.94% 7.99% Lemon Song Credit Card $39,134 54 1.16% 1.47% Lease $4,096 7 0.12% 0.19% Prepaid $181,755 262 5.40% 7.15% Lemon Song Total $224,985 323 6.68% 8.81% Lily Lin Credit Card $9,479 7 0.28% 0.19% Prepaid $513,412 418 15.25% 11.41% Lily Lin Total $522,891 425 15.53% 11.60% Richard Zhou Credit Card $30,804 45 0.91% 1.23% Lease $4,616 4 0.14% 0.11% POD $4,106 6 0.12% 0.16% Prepaid $127,910 186 3.80% 5.08% Richard Zhou Total $167,436 241 4.97% 6.58% Wendy Wang Credit Card $44,665 47 1.33% 1.28% Lease $4,091 4 0.12% 0.11% POD $3,004 4 0.09% 0.11% Prepaid $156,990 202 4.66% 5.51% Wendy Wang Total $208,750 257 6.20% 7.01% Grand Total $3,366,676 3665 100.00% 100.00%

weslley07

这是什么东东啊？

penghaifeng

上传个Excel 版的吧!~~

xiaopei18

你发的是什么？
怎么都看不懂？

1199

这个看得眼花，什么意思哦