So I assume there is a good reason you don't want to use the inbuilt Tableau hierarchy, were you can use the + above each level to expand and collapse the levels?
If so one way would be to use a sheet swap...here is a KB article on how it's done (btw I changed your parameter to integers, with Alias for display...just makes the formulas a bit easier for me!)
Hope this does the trick
Not used Tableau 8 for ages...amazing how quickly the software moves on!
Hierarchy_sample - 8.3.twbx 980.8 KB
Thanks for your reply. I could go back to the default Tableau hierarchy if I have to, but this would work better with some other things I'm trying to do.
I'm familiar with sheet swapping, but was trying to avoid it as I'd have to create 20 additional sheets in my actual dashboard. It would solve my problem, but doesn't scale as well as I'd like. I'll probably just go back to the built-in hierarchy.
We're supposed to upgrade to Tableau 9 any day now.
Yes if you have several vizes shown at Level X, and when the user changes the level...it's nice if all the Vizes expand out (which the parameter technique does), whereas with the default hierarchy the user has to click the +/- o each one...unfortunately headers and axis are either shown or not-shown...and don't allow dynamic control (in that way).
You'll love Tableau 9!...although 10 is just round the corner too. I can't think of anything new in them that would be of help here (Tableau 10 does have workbook formatting, so a 20 dashboard model would be slightly more scalable, i.e if you want to change the font, say, it no longer needs you to edit all 20).
If anything else comes to mind I'll post back