how to limit the dimensions in alternate states

[#1]

Hi,

I'm figuring out the new comparitive analysis.

What I need is 5 list boxes on the same dimension: CustomerId.

When a customer is selected in 1 listbox (alternate state A), it should not be possible to select in listbox 2 (alternate state B), etc. for box 3 to 5

When comparing the sets I do not want the same customers in more than group.

Any ideas?

Thx,

Johan.

[#2]

Something like this should work for listbox 2:

Aggr(Max({$<CustomerId=P({Alt State B}CustomerId) - P({[Alt State A]}CustomerId)>}CustomerId),CustomerId)