you could do this a couple ways.
1) use a parameter to switch between different Dimensions
2) reshape your data.
I've attached a workbook that shows both versions.
Hope this helps.
Multiple Filters into 1.twbx.zip 60.2 KB
Thanks for your reply. I like your first solution best, as I'd like to avoid reshaping the data, if possible. If I go to 'edit' the Honor parameter, I can see the elements, but I don't know how to set it up the way you did. Would it be possible to provide some basic instructions. I'm sorry, I'm just getting started with the software and haven't had any training (besides watching some of the videos, but I couldn't find how to do this in the videos). Also, will this work if I want to show the average/median gpa's of entire graduating classes (or members of graduating classes who had various distinctions) by year, rather than showing individual record data?
You can do this multiple ways. (like everything in Tableau) Here's one of them.
1) Right click in an empty space in your Dimensions window and Click “Create Parameter” (similar to creating a Calculated Field)
2) Give the Parameter a name that makes sense “Honor” in this case.
3) Set the Data Type . This one was a list of different Dimensions to choose from so I set it to “String”
4) Set the Allowable Values to “List”. This will allow you to type in the values you want.
5) Type in the names of the Dimensions into the value list. “School honors”, “Department Honors” ets.
You are now done with the Parameter. Now you have to create a Calculated Field that calls on that Parameter. See the Parameter Calc in the previous workbook.
Thanks for the instructions! I was able to get it working just the way I wanted with your help. And, I really like your model bar charts with the background fill to show above/below the trend - great visual technique/practice. There's just one last thing that is befuddling me, and that is how Elmer Fudd ended up with Highest distinction. ???? ;-)
Thanks Jeff, its helpfull.
Havingg trouble using this solution.
I get the first part but then for the calculated Field I run into the issue that my dimensions are attributes pre designed in a Cube, and I cant finish the formula.
if [Sales Trend Analysis]= 'last 12 months' then [Date].[12 Month Trend Analysis].&[last 12 months]