Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Put something like this:
if(GetFieldSelections( {[State1] <[Field of list box goes here]= >} Condition) = 'Closed filters', 'A', 'B')
Hope it helped
are you sure that in GetFieldSelection i can use operators {<>} ?
Can you please write some example..
Your solution gives me an error.
I don't think GetFieldSelections() function takes in Alternate State information like this Braga. See below:
I've overlooked that, sorry
No worries
maybe there're some else function, which will in calculated dimension check values from listbox with ignoring alternate state?