Thanks for your response. In relation to your example, I would only want to be able to select a single state at a time. I dont want Tableau to sum totals for multiple states. To aggregate this type of data requires complex rules which we are applyied through an ETL process, external to Tableau. The requirenments for the dashboard require a user to see both the pre-calulated aggregate data and the single location data.
Where you able to find a solution for this? I'm having the same problem.