Is it possible to filter pivot table rows based on a variable for only one value of a dimension?

[DJF]

I'm hoping someone can take a look at the attached sample file and tell me if it's possible to set up qlikview to filter rows out of the pivot table based on the sum(amount) expression using a variable/slider.

I'd like to set it up so that it only displays rows in the pivot table when the 2019 sum(amount) value is greater than or equal to the value set by the slider.

Is that possible to do?

[fosuzuki · Accepted solution]

Try changing the expression to:

If(sum(Amount)>$(vThreshold), sum(Amount))