2 of 2 people found this helpful
Yes, ofcourse you can!
First create a string parameter, like shown below. I used category and sub category dimensions. You would use the dimensions as in your data source. Then create a CASE calc over that parameter. Finally drag the new calc on the view instead of the individual dimensions:
So now when I have category as my selection I see the sales breakdown by category. When I have sub-category selected the sales breakdown changes by the new dimension. Is this what you want? Let me know!
Many thanks for your help on this. Helped me a lot.