I am having a set of dimensions say - Sales Rep, Sales Manager, Regional Sales Manager. I have created a parameter, so that based on the dimension selection, the measures would display accordingly.
I also have a hierarchical dimension, which I want to add to the parameter list of dimensions, so that when I choose that value, the table would have a hierarchical dimensions added. How to add a hierarchy / dimension group added ? As an alternative approach I have appended the dimensions but can I get it as hierarchy ?
Please upload a 'packaged worked' based off the 'superstore' data if you want to keep you actual data discreet.