Dear all,

I have a pivot table that showing the following data:


Sum of Sold Qty Shop A Shop B

Item A 10 5
Item B 20 10
Item C 10 15

Total 40 30


But my boss asked me to make a pivot as follow:

Accumulated% of Sold Qty Shop A Shop B

Item A 25% 16.67%
Item B 75% 50%
Item C 100% 100%

Total 100% 100%

I think it's quite stupid to present it this way... but have to do it....
I've been working around the stuffs such as calculated formula in pivot
table but seems nothing can help, it has made me crazy... So anyone knows how
to do it? Thanks in advance!!!