Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
ok, this seems to be working, I need to test further:
=aggr(only({<ASSET_CLASS=P({A}) * P({B})>} ASSET_CLASS), ASSET_CLASS)