Allow users to select different combinations of hierarchies in Matrix

[dreww2]

Hello,

I have users that like to see raw data in matrix tables, and often they want to see data in the matrix "cut" by different variables.

For example, if I have a matrix showing sales, some of the variables of interest that users would want to see cuts might be (1) age, (2) gender, (3) state, (4) product line, and (5) company division. 

Right now, I can create a matrix and include each of these variables as nested rows which allow a user to drill from one hierarchy to the next, which works fine.  But what if a user wants to see a combination of two or more variables together?

For example, if one user wants to see sales segmented by (1) age and (3) state, but another user wants to see sales by (3) state and then (4) gender, it's not possible (I don't think) for users to specify the order of the hierarchy they want to see to get to the combination of variables they want to see in the output.  

How have you handled similar situations?   You can solve this by creating bookmarks for every possible combination, but that is really inefficient and time consuming to implement.  Is there anything simplier to try that I might be missing?

Thanks.

[dreww2]

This is exactly what I was looking for, and I had missed it as part of the May release.  Thank you so much.

[vanessafvg · Accepted solution]

the new feature field parameters might be a perfect solution to this.  This way you can combine fields from different tables, and also the order in which you select the field parameters depends on the order you click them in which works perfect for the custom hierarchies you are looking for.

check out this video by sqlbi and see if it will work for you  

https://www.youtube.com/watch?v=TufnsAxJsjs&t=936s