conditional aggr() function use

[gerrycastellino]

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.