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 ?