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

    Parameter with one non-hier dimension and one hierarchy dimension

    Lauren Schmidt

      Hello,

      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!!

      Lauren