Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Something like this should work for listbox 2:
Aggr(Max({$<CustomerId=P({Alt State B}CustomerId) - P({[Alt State A]}CustomerId)>}CustomerId),CustomerId)