Pivot Table Percentages

rsokoloff

New Member
Joined
Feb 7, 2015
Messages
5
Hello,
I have monthly sales data for 5 salesmen and I wish to chart % sales per month. This is straightforward when viewing ALL 5 sales men but a mess when only viewing a subset of the 5. For example: If total sales are 1,000 and each salesman sells 200 than each sold 20% that month and if I view all 5 that's what the calculation/chart shows (Show as % Row). But when viewing a subset of salespeople the grand total changes and the percentages change. There must be a workaround but I am stumped. Thanks.

Sum of wRVU Column Labels
Row Labels Cortez Duffy Icenogle Sokoloff Thompson Van Grand Total
Jan-14 29.13% 2.08% 54.54% 0.00% 13.13% 1.11% 100.00%
Feb-14 34.56% 0.14% 44.94% 0.00% 17.80% 2.57% 100.00%
Mar-14 18.46% 3.16% 55.17% 7.91% 14.86% 0.45% 100.00%
Apr-14 10.56% 0.00% 48.55% 32.74% 8.15% 0.00% 100.00%
May-14 11.33% 1.49% 41.97% 40.65% 4.16% 0.41% 100.00%
Jun-14 9.58% 0.00% 43.09% 41.35% 5.58% 0.40% 100.00%
Jul-14 10.23% 0.00% 47.29% 37.47% 4.06% 0.94% 100.00%
Aug-14 7.92% 0.00% 55.10% 34.34% 2.59% 0.05% 100.00%
Sep-14 9.87% 0.00% 56.62% 31.01% 2.50% 0.00% 100.00%
Oct-14 11.12% 0.00% 57.97% 30.23% 0.57% 0.11% 100.00%
Nov-14 10.72% 0.00% 63.17% 24.14% 0.00% 1.96% 100.00%
Dec-14 10.56% 0.00% 59.72% 29.71% 0.00% 0.00% 100.00%
Jan-15 10.27% 0.00% 58.71% 30.88% 0.14% 0.00% 100.00%
Feb-15 10.34% 0.00% 52.02% 37.61% 0.00% 0.03% 100.00%
Mar-15 9.87% 0.00% 55.84% 34.28% 0.00% 0.00% 100.00%
Apr-15 9.02% 0.00% 56.84% 34.15% 0.00% 0.00% 100.00%
Grand Total 13.07% 0.42% 53.13% 28.41% 4.50% 0.47% 100.00%


------------------------------------------------------------------------------------------------------------

Sum of wRVU Column Labels
Row Labels Cortez Icenogle Sokoloff Grand Total
Jan-14 34.82% 65.18% 0.00% 100.00%
Feb-14 43.47% 56.53% 0.00% 100.00%
Mar-14 22.64% 67.66% 9.70% 100.00%
Apr-14 11.50% 52.86% 35.64% 100.00%
May-14 12.06% 44.67% 43.27% 100.00%
Jun-14 10.19% 45.83% 43.98% 100.00%
Jul-14 10.77% 49.78% 39.45% 100.00%
Aug-14 8.13% 56.60% 35.27% 100.00%
Sep-14 10.12% 58.07% 31.80% 100.00%
Oct-14 11.19% 58.37% 30.44% 100.00%
Nov-14 10.93% 64.44% 24.63% 100.00%
Dec-14 10.56% 59.72% 29.71% 100.00%
Jan-15 10.28% 58.79% 30.93% 100.00%
Feb-15 10.35% 52.04% 37.62% 100.00%
Mar-15 9.87% 55.84% 34.28% 100.00%
Apr-15 9.02% 56.84% 34.15% 100.00%
Grand Total 13.81% 56.16% 30.03% 100.00%
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Let repost less data. Hpefully it will be easier to se.

Sum of wRVU Column Labels
Row Labels Cortez Duffy Icenogle Sokoloff Thompson Van Grand Total
Jan-15 10.27% 0.00% 58.71% 30.88% 0.14% 0.00% 100.00%
Feb-15 10.34% 0.00% 52.02% 37.61% 0.00% 0.03% 100.00%
Mar-15 9.87% 0.00% 55.84% 34.28% 0.00% 0.00% 100.00%
Apr-15 9.02% 0.00% 56.84% 34.15% 0.00% 0.00% 100.00%
Grand Total 9.87% 0.00% 55.91% 34.17% 0.04% 0.01% 100.00%



Sum of wRVU Column Labels
Row Labels Cortez Icenogle Sokoloff Grand Total
Jan-15 10.28% 58.79% 30.93% 100.00%
Feb-15 10.35% 52.04% 37.62% 100.00%
Mar-15 9.87% 55.84% 34.28% 100.00%
Apr-15 9.02% 56.84% 34.15% 100.00%
Grand Total 9.87% 55.94% 34.19% 100.00%
 
Upvote 0

Forum statistics

Threads
1,215,440
Messages
6,124,882
Members
449,193
Latest member
PurplePlop

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top