here is an example using superstore furniture sales

then create a filter

place it on the filter shelf and set to true

and you get this 

without the filter it is this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

I understand

but since you did not share your twbx workbook I had to make up something to show you that you can use filters to on a calculated field value -

if you have a twbx workbook please post  it and I will show you how in your data

JIm

Jason

try    sum(Profit)<>2000   as a filter and set to True

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.