There is action filter in Geography Table ,try to remove this and select Geography Level data is showing correct aggregation.
Let me know if it is not working
Thank you for replying. If I remove the filter, the sheet & dashboard display all of the subregions in the parameter instead of just the one pertaining to the selected locality.
Interesting that when I select "Richmond City" or "Alexandria City" while in Community Service Board Comparison Class and switch to Local Health District the Comparison Class column does not revert to null.