# Accumulated percentage calculation

Terence C
Guest
Posts: n/a

 20th Apr 2009
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!!!

Rodriques
Guest
Posts: n/a

 20th Apr 2009
Hi,

Count of Sum of Sold Qty Shop
Sum of Sold Qty A B Grand Total
Item A 25.00% 14.29% 20.00%
Item B 50.00% 57.14% 53.33%
Item C 25.00% 28.57% 26.67%
Grand Total 100.00% 100.00% 100.00%

After you complete your pivot table, then double click on count of Sum of
Sold Qty, Pivot table field Table will appear, then click the drop down box
of show data as & then select "% of COLOUMN".

Bye.

"Terence C" wrote:

> 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!!!
>
>
>

Herbert Seidenberg
Guest
Posts: n/a

 21st Apr 2009
Excel 2007
Cumulative % of subcategory.
Way complicated.
http://www.mediafire.com/file/mxj55naohaw/04_20_09.xlsx

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post tevawe Microsoft Access 6 4th Sep 2008 08:43 PM Frank Dulk Microsoft Access Forms 11 25th Mar 2004 02:44 AM Frank Dulk Microsoft Access Queries 0 23rd Mar 2004 03:45 AM JOHN ALDEN GREEN Microsoft Outlook Discussion 1 4th Feb 2004 06:16 AM henrycheung Microsoft Excel Programming 2 24th Jan 2004 11:34 AM

Features