how to remove lines with 0 values in a pivot table?

[#1]

I created a pivot table for all products we sell. There is around 900,000 positions listed.

Most of them is not in stock and I don't want to see them listed.

this is the expression used:

sum({$<[Stock Flag]={'Y'}>}[Location Quantity])

how to remove/not show lines with 0 values in my pivot table?

thanks

[Anil_Babu_Samineni]

First try with default options like Suppress null value

And then, May be this?

sum({$<[Stock Flag]={'Y'}, [Location Quantity] = {"=Sum([Location Quantity])>0"}>}[Location Quantity])

[#3]

I already tried ''Suppress null value''

I've been reading this is not working for pivot tables

your solution didn't work. nothing happened.

I tried something before and it removed all values and put " - " instead, but this time nothing has changed

I filtered some data so I can have only few records

see below (stock qty is the column I need to work on)