3 Replies Latest reply: Apr 9, 2014 10:23 PM by Ramkumar Ramagopalan RSS

    Alternate state in calculated dimension - Set analysis

      Guys,

       

      I have two alternate states, one is <inherited> the other one is <Healthy_Food_State>...

       

      I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...

       

      Can you guys say to me a possible expression?

       

      I am trying something like:

       

      =only({$<item_substitute= ::[Healthy_Food_State]>}item_substitute)

       

      I do suck at those kind of expressions.

       

      Can you guys tell me a possible solution for that?