Issue on report filter

[Shawn33]

Hi ,

There is a custom report in my instance on "hardware" table, type is "multi level pivot table" and configuration and filter conditions attached screenshot 

>Once run the report count will populate below.
>and I click on total count then it is open in new window.
>I observed that an additional filter got added on query "disposal reason is none" which we not added on report level.
  attached screenshot 

--> Question is why an additional query got added into query in list view as shown in above image even that we not added on report level conditions?

[Voona Rohila]

Hi @Shawn33 

You can add condition like this

Disposable reason || is not empty 

AND

Disposable reason || is not of || [your choices]

[Shawn33]

Hi Voona Rohila,
Disposable reason || is not empty
can't select operator "is not empty" because it's a dropdown field type!

[Voona Rohila]

Hi 
I tried with dropdown field and I could see that option

Can you please share screenshot?

[Shawn33]

Hi,
here is my view

variable screenshot