1 Reply Latest reply on Aug 3, 2018 2:43 PM by Patrick Van Der Hyde

    Parameter with one non-hier dimension and one hierarchy dimension

    Lauren Schmidt


      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.


      Thank you!!