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
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.