Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 2 value in listbox.
Steve, keen
How to show listbox by excluding 1 value?
below expression in listbox is not working.
if(Owner = 'Steve',Owner)
It should work as you have written, but take care to input the expression in the field <expression> (from field drop down on general tab),not on expression tab.
it is coming like this, keen is still visible
As I said, you need to enter the expression on general tab, like a calculated dimension, not a measure:
Hi
Are you Expecting like this
Try
=AGGR(if(Owner = 'Steve',Owner),Owner)
or
=AGGR( Only ({<Owner ={'Steve'}>} Owner) , Owner)
done thanks