Alternate state, aggr function for intersection of 2 dimensions

[gerrycastellino]

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.

[gerrycastellino]

ok, this seems to be working,  I need to test further:

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