Chart properties subtotals and weighted averages

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
RepsShippedShipped Plan% to Plan
Rep 1105200%
Rep 2101567%
Rep 35045111%
Rep 4607580%
Rep 54540113%
Rep 6101191%
Total185191661%
    
Currently with Average
RepsShippedShipped Plan% to Plan
Rep 1105200%
Rep 2101567%
Rep 35045111%
Rep 4607580%
Rep 54540113%
Rep 6101191%
Total185191110%
    
How it should be /w Weighted Avg.
RepsShippedShipped Plan% to Plan
Rep 1105200%
Rep 2101567%
Rep 35045111%
Rep 4607580%
Rep 54540113%
Rep 6101191%
Total18519197%

 

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

 

Best Answer

  • cmarutzky
    Accepted Answer

    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.

Answers

This discussion has been closed.