1 Reply Latest reply on Apr 4, 2016 11:20 PM by kumar.c

    dynamic columns using parameter?

    Simon Willis

      I would like to swap out multiple columns using a parameter

      Say I have hispanic pop, hispanic % and hispanic index as calculated measures in columns, how can I change to other ethnicities using a parameter?

       

      thanks,

        • 1. Re: dynamic columns using parameter?
          kumar.c

          Hi Simon,

          Create calculated parameter with type as string if you want to swap between measures as below:

          Step 1. Parameter with list of measures

          Step 2. Create calculated field like below:

               CASE Parameter

               when "Hispanic pop" then Hispanic pop field

              When "Hispanic %" then Hispanic % field

              when "Hispanic Index" then Hispanic index

          end

          drag this calculated field on to the column shelf with any dimension that you want to use.

          1 of 1 people found this helpful