How to hide some rows based of criteria resulting from expression with set analysis

[epapathanasis]

Hello,

I would like to hide rows in a pivot table when the result of expression is less or equal to 0.

Here is the exrpession: 

sum({<SalesDate={"$(='>=' & date(today()-365) )"} > } [Sales Amount])

[epapathanasis · Accepted solution]

Finally, I have decide to add new expression: if (Column(n) <= 0, Column(n)), who is referred to initial expression, wich i hid. And the problem solved.