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.