I apologize if my question is extremely basic. I just started using tableau (3 days).

Consider Sales of a firm that is present all over the US. The sales data is available by State and the City.

What I need is, when I input the city, the report should display the sales for the entire state by city.

For example, consider there are three cities (Dallas, Austin, San Antonio) in Texas. If I input Dallas (I am using a parameter), then the report should show sales for all the Cities in Texas. For this case, the report should show sales in Austin, Dallas, San Antonio in the following order - State, City, Sales.

I would like to thank you for your help.