Hey everybody-
I'm relatively new to Tableau, so I would appreciate your help with this.
Basically what I'd like to do allow the end user to expand and contract hierarchies on the row shelf
Take the Superstore Sales for example... Let's say I have the following hierarchy:
1) Region
2) State
3) City
I would like the end user to look control the view so he can look at sales data by:
1) Region
2) Region►State
3) Region►State►City
Is there a way to set up a parameter control which either allows the user to change the rows on the shelf? Or a way to chose the level of hierarchy that's active?
Any help would be much appreciated!
Yes--using a parameter, you can allow the user to choose either "Region", "State", or "City" to modify the view accordingly. This is a pretty good place to start:
Changing Views Using Parameters | Tableau Software
Once you do this once, it becomes easier every time and it can really save some time and dashboard space down the road. Best of luck, let us know if you have any trouble setting it up.