16 Replies Latest reply: Sep 30, 2016 8:17 AM by Hannah Lines RSS

    Set Analysis with Set Modifiers and Variables

    Hannah Lines

      Hello,

       

      I am trying to use Set Modifiers within Set Analysis by using a variable. Very similar to the "Set Modifiers" portion of this thread. Set Analysis

       

      Using the example below, I want to have 'West coast' and 'South America' replaced with a variable.

      sum( <[Sales Region]={'West coast', 'South America'}>} sales)

       

      where $(vExampleVariable) = 'West coast', 'South America' I want to use the following:

      sum( {<[Sales Region]={$(vExampleVariable)}>} sales)

       


      I have tried many different ways of writing the set analysis but can't seem to get the correct syntax.