conflict between alternate states

[Anonymous]

Good day!

In my model i have one listbox (with default alternate) wiich have field Condition : 'Total', 'Closed filters'

Also i have one pivot table (with alternate 'State1'), which have one calculated dimension:

if(GetFieldSelections(Condition)='Closed filters', 'A', 'B'), but it's no working. I think it's connected with defferent alternate states in listbox and pivot.

Is there any way to solve this problem?

Thanks.

[miguelbraga]

Put something like this:

if(GetFieldSelections( {[State1] <[Field of list box goes here]= >} Condition) = 'Closed filters', 'A', 'B')

Hope it helped

[Anonymous]

are you sure that in GetFieldSelection i can use operators {<>} ?

Can you please write some example..

Your solution gives me an error.

[sunny_talwar]

I don't think GetFieldSelections() function takes in Alternate State information like this Braga. See below:

[miguelbraga]

I've overlooked that, sorry

[sunny_talwar]

No worries

[Anonymous]

maybe there're some else function, which will in calculated dimension check values  from listbox with ignoring alternate state?