1 Reply Latest reply: May 22, 2015 3:48 PM by gerry castellino RSS

    Alternate state, aggr function for intersection of 2 dimensions

    gerry castellino

      I have a dimension asset_class,  that I want to change based on the intersection of 2 other dimensions that are in alternate state(s)

      A, B.

       

      How do I structure my asset_class expression to list this intersection ?

      I'm trying something like the below, but need help ....

       

      =aggr(only({A*B} ASSET_CLASS), ASSET_CLASS)

       

      Is the aggr function to only way to achieve this ?

       

      Gerry.