Apply filter on Table only

[Anonymous]

I have a data set containing Sales by date and transaction #.

I want to build a table containing only sales which is over $1000. How can I add a filter to show only transactions with sales over $1000?

Please help.

Thanks,

Amit

[sunny_talwar · Accepted solution]

May be use a set analysis like this

Sum({<[Transaction_ID] = {"=Sum(Sales) > 1000"}>}Sales)

[Anonymous]

Thank you.. that did the trick!