I have a worksheet that I originally created to switch between two dimensions - Product Category and Warehouse. I used a parameter to allow the end-user to switch between those two dimensions. Customer has now requested that the product category be a hierarchy - Category 1 and then Category 2. The warehouse dimension will still be one level, though.
Is there a way to allow the end user to still switch between a Product Category View or the Warehouse view when the Product Category is a hierarchy and the warehouse dimension is NOT a category? Or a work-around?
I have attached my workbook.
The current parameter in the workbook is pulling the "Category 1 field" but I would like that Product Category option to pull in the Product Hierarchy Dimension.