Total Mode: Expression Total - How to get accurate average
I have a Chart of calculated averages. I wanted to have a Total Row at the bottom and I'm not sure what 'Expression Total' is calculating but it isn't what I need. Since each calculated value uses a different denominator I need to sum the numerators and divide that by the sum of denominators. Merely Averaging the averages will not work. Am I only able to accomplish this by creating my own Total Row with some complicated expressions? If so how do you reference values from other parts of the Chart.