Saketh

Thank you for your prompt response @amehdad . So just to clarify the total row doesn't consider the beast mode formula but instead, just considers the same column and gives us the total avg percentage? i.e its adding bunch of %'s that precede the total row and gives me the final value instead of calculating column6/ column…

@MarkSnodgrass - Thank you for the above fix. Quick follow-up question - would the averages displayed be a weighted average or is it a simple average??

@danidiaz - you have an option to hide the "other" category on your card under the general chart properties section!