Here's my situation:
I have a list box "fieldA"
I'm trying to implement a conditional aggr() function for this list box, which will be driven if a dimension from fieldB is selected or not.
Basically, I'm trying to get a statement working as follows:
=pick(if(not(isnull(only({[State1]} fieldB))),1,0)+1,
aggr(only({<ASSET_CLASS=P({State2}) * P({State3})>} fieldA), fieldA), // performs a union from states 2,3
aggr(only({<ASSET_CLASS=P({State4}) * P({State5)>} fieldA), fieldA)) // performs a union from states 4,5
The list box does not seem to be supporting this construct, not sure how I can re-arrange this.
Gerry.