Hello! Thank you in advance for any and all help! I currently am setting up a chart where I have a list of instances of coffee buyers, the amount they purchase, and the amount they spend. I would like to create a sheet object where I can select all of the coffee buyers who spend above a certain amount (say $14). Does anyone know how to do this? I've tried using the trigger field in variables, but the search string field doesn't seem to like/work having an if statement in it.
For more clarifcation, my chart looks like this:
Coffee buyer amount purchased amount spent
A 5 kilo 10
B 7 kilo 8
C 15 kilo 20
B 6 7
D 10 15
A .5 1
How would I be able to select all coffee buyers who spend less than $14 (ie select all coffee buyers but A)
