You can create a hierarchy.
Here is what I did:
1. Select the multiple fields you need and create a hierarchy.
2. You can change the order of the columns in the hierarchy as you want by dragging a column and placing it where you need it.
3. You can now place the hierarchy column into the worksheet and the required measures.
4. Click on the "+" in the hierarchy column placed and it will now expand to show the second level.
5. Click on the "+" again to see the third level.
Hope this helps.
On Tableau server (9.0 and above) Users can edit sheets using web authoring capability (and not require downloading of the workbook to edit and republish). However that is an option that has to be turned on within your server installation by an admin, and your users need to have the right level of permission. Please review the following.
Also review this for the right level of permissions that your users will need: Set Web Edit, Save, and Download Access on Content
Thank you for your solution. This helped in clarifying that I could create hierarchy even if the dimensions are not directly related.
But I think this solution still does not give the end user the complete ability to slice the data as they need. For Example: Lets consider I have one measure and 3 dimensions: Measure = Total Sales, Dimensions: Date, Region, Product.
Date dimension has hierarchy - year, quarter, month
Region dimension has hierarchy - continent, country
Product dimension has hierarchy - ProductCategory, SubProductCategory
In the default workbook, that is published - It will have Date and Total Sales. But I want the end users to choose any additional dimensions and slice the data further.
So, as suggested above, I can create hierarchy between Date, Region, Product and let the end user slice the data per hierarchy level.
But If the end user wants to slice the data only Date, Product, I think the data will still be sliced by Region since it is the second level in the hierarchy chain.
Is there a way to get around this problem? Thanks again for your help.