Hey all, i recently started using pivot tables in excel 365

in my data set i got some lines with 0 values. i want to filter out those values from my pivot so count for example does not include them.

i tried setting value filter on the needed field > 0 but nothing.

i tried setting value filter on the needed field > 0 after adding the field in the rows of the pivot and it seems to work.

the problem is the solution looks ugly as i display unnecessary values in my pivot this way!

i cant imagine there is no way to filter without displaying the values??

any ideas?

thx!