1 of 1 people found this helpful
You would need to create a calculated field and a parameter, if you wanted to let the end use dynamically change the threshold cutoff. First build the parameter to be a list or range of integer values. Then in the calculated field, you'd reference the parameter as follows
[SALES]>[PARAMETER] (boolean, t/f)
then add this new calculated field to the colors shelf. You might need to modify this a little bit based on your view (unsure without a sample workbook), but this should get you in the right direction.