Sorry to be a bother, I can’t figure out how to get the state to total as you did with yours. How did you create sumbystate and sumbycounty?
Sorry, I made a mistake earlier. Here is Correct One.
and Formula for By City
Add State Filter to Context, but not the City
If it Helps, Pl mark it Helpful and CORRECT to close Thread
Do you have the State totals as well as the County totals ? (you'll probably want the State average because it makes more sense).
If you don't have the State data, you can probably create a calculated field to do it, but you will need a County/State hierarchy to make it work.
Any chance you can attach some dummy data to help ?