I have a list box that is powered by an expression to hide 1 value.
=aggr(only({<[name]-={John}>}[name]),[name])
But i want to add a second name to this. I have tried...
=aggr(only({<[name]-={John, Alan}>}[name]),[name])
And
=aggr(only({<[name]-={John}, {Alan}>}[name]),[name])
Single quotes are required to indicate explicit values:
=aggr(only({<[name]-={'John', 'Alan'}>}[name]),[name])