Filter data based on value

[#1]

I am trying to develop a detailed list of claims data in a table for an insurance company.  I'd like to be able to create filters so that I only show claims that have loss values greater than $10,000 and a second filter to display claims with values greater than $25,000.  Can anyone help me with how best to do this?  My objective is to be able to cycle through the same table but only showing claims greater than those two values.

I have attached a overly simplified version of the data

[its_anandrjs · Accepted solution]

Hi,

You need to write for straight table like

Dimension -> Claim #

Dimension -> Policy #

Expression -> If( [Loss Paid] >= 10000 or [Loss Paid] >= 25000, [Loss Paid])

Rgds

Anand