
1. Re: Weighted Average Subtotals and Totals
Jim Dehner Aug 21, 2017 12:22 PM (in response to Dan Burrell)Dan if I understand the question you have calculations that properly calculate a weighted average at the individual entity level (say state) and when you use Grand Total/Subtotal you are questioning what is being returned (i.e is it the average)
When you use a calculated field combined with total or subtotal  the aggregated value represents the formula as applied to the total of the components 
for example it is not the sum or average of the values in the column  it is what you would get by using the formula on the "Grand total/subtotal" value on the columns
Hope that helps  it doesn't sound like it is the answer you wanted
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.