Chart properties subtotals and weighted averages

DMJerry

Hello,

 

Hope you all are having a great week.  I have a question about one of the new analyzer additions(which I Love) and in particular chart properties Total Row sub-totalling.  It works great for summing up values but when it comes to showing total %, to let's say % to plan, it totals all the %'s and doesn't use a weighted average that the beastmode used.  Here is an example:

Currently with Sum
Reps	Shipped	Shipped Plan	% to Plan
Rep 1	10	5	200%
Rep 2	10	15	67%
Rep 3	50	45	111%
Rep 4	60	75	80%
Rep 5	45	40	113%
Rep 6	10	11	91%
Total	185	191	661%
Currently with Average
Reps	Shipped	Shipped Plan	% to Plan
Rep 1	10	5	200%
Rep 2	10	15	67%
Rep 3	50	45	111%
Rep 4	60	75	80%
Rep 5	45	40	113%
Rep 6	10	11	91%
Total	185	191	110%
How it should be /w Weighted Avg.
Reps	Shipped	Shipped Plan	% to Plan
Rep 1	10	5	200%
Rep 2	10	15	67%
Rep 3	50	45	111%
Rep 4	60	75	80%
Rep 5	45	40	113%
Rep 6	10	11	91%
Total	185	191	97%

 

I hope that this is easy and that I'm not missing a field/checkbox on the chart properties but hoping I can get some direction.

 

Thank you,

 

Jerry Heard

 

cmarutzky

On my cards, if a column is a beast mode then the subtotal and grand total calculate based on the Beast Mode rather than a straight sum.  I remember talk about making other functions available on Subtotal/Total rows (like average, max, min, etc) but haven't see that yet.  Not sure why this wouldn't be working in your instance.

Chronos

Is anyone able to help out with this request?

cmarutzky

On my cards, if a column is a beast mode then the subtotal and grand total calculate based on the Beast Mode rather than a straight sum.  I remember talk about making other functions available on Subtotal/Total rows (like average, max, min, etc) but haven't see that yet.  Not sure why this wouldn't be working in your instance.

DMJerry

The funny is that it is working now.  Thanks for the input.