1 of 1 people found this helpful
I just responded to your similar question on this thread: http://community.tableau.com/message/184940, the suggestion is to use a parameter to control what path of the hierarchy is being displayed, like in this example: http://www.clearlyandsimply.com/clearly_and_simply/2012/03/dynamic-hierarchies-with-tableau.html.
Thanks Jonathan. The response to my query on the other question has helped. WINDOW_MIN() seems to do the trick for now.