6 Replies Latest reply on Nov 9, 2016 9:16 AM by Mark Tubis

    swapping one measure for two or more

    Mark Tubis

      Is possible to swap one dimension for two or more.

      I have defined a parameter that allows the user to select the dimension but would like it to in some instances swap the one dimension for two or more

       

      Current (swap one dimension for another)

      Case [Classification Group]

      when "Segment" then [Segment]

      when "Asset Class" then [Asset Class]

      when "Sub Asset Class" then [Sub Asset Class]

      end

       

      Desired (swap one for many but with each as a separate pill)

      Case [Classification Group]

      when "Segment" then [Segment]

      when "Asset Class" then  [Segment]+[Asset Class]

      when "Sub Asset Class" then Segment]+[Asset Class]+[Sub Asset Class]

      end