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