I am not sure where you are heading with this approach, here are few thoughts.
Multiple field effect can be achieved to certain extent by creating calculated fields with multiple columns(combined). You need to identify all such combinations and there calculated fields.
Note: You cannot use combined fields in other calculations hence calculated fields.
Other approach would be create multiple sheets with all desired combinations and switch those sheets based on parameter selection
Thanks for the reply Amit.
> I am not sure where you are heading with this approach
The goal is to allow user to select "GroupBy" dimensions from a predetermined list (not as a merged column, but each individual dimension should appear in the Rows shelve) instead of having to choose them one at a time as suggested in the article Changing Views Using Parameters | Tableau Software. Ex. Selecting Dim1-Dim2 from the parameter drop down should result in showing TWO SEPARATE columns Dim1, Dim2 in the dimensions pane. (This is as opposed to providing n number of parameter drop downs and then having user select Dim1 and Dim2 in 2 separate drop downs). I hope this is clear enough.
> Other approach would be create multiple sheets with all desired combinations and switch those sheets based on parameter selection
Yes.. sort of what I did, only problem is when I've changes each and every sheet has to be fixed. BTW: Is there a way to show and hide sheets (when user selects a different combination)?
You're on the right track with what you are doing.
The idea is to create 2 dimension pills that each would include the various dimensions that you would be using.
For example; Dim1 would be 'Category', Dim2 would be 'Region', and so on...
First off, is to create your parameter:
Here are the 2 pills that I've created in the example that I have attached:
Now, I've placed each pill, one on the rows shelf, and the other on the columns shelf just for the example. I've also added 'Sales' to the mix...
...and here's what you get:
See the attached packaged workbook to review.
Hope this helps.
multiple sheets within container and sheet selector would give same appearance of hiding sheets.only downside, with good number of sheets you are likely to see space horizontally or vertically
Oh this is a very interesting work around.. Thanks so much for the very detailed explanation / answer Don.. you are the best.
Thanks for sharing your thoughts Amit. I'm going to try and use Don's approach. I believe, that should solve the problem at hand.