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

    Set Analysis with Set Modifiers and Variables

    Hannah Cozad



      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.