Select all but one Values via Filter Formula

[Tim_G]

Hello there,

I would like to set up a new bookmark. There I woul like to select all but one values in a specific dimension.

Usually if you want to select specific values in the dimension you go like this:

=[Dimension]={'0'}

However I woul like to select all but the zero. I tried something like this but it does not work:

{"[Dimension]={"<>[Dimension]={'0'}"}

Anybody has an idea?

[vincent_ardiet_]

You can try just with:
=Dimension<>'0'

[TcnCunha_M]

Hi

Use  "-= " value you want

[Tim_G]

Does not work either with <> or -=. If I do so only the zeros are selected which I want to avoid. Does not make sense to me:

[Offene Menge] is my Dimension and is a number, including negative values. Omitting the brackets {} gives an error with no selected values.

[vincent_ardiet_ · Accepted solution]

First clear all selections and type =[Offene Menge]<>0

[Tim_G]

Works now. That was a variant I missed during trial an error. Thanks!

[F_B]

If you select the value zero from your filter,

then, clicking on the three points you can use the filter option

-excluded-