Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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.
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.