1 of 1 people found this helpful
You can do this by creating a calculated field similar to the following:
if sum([threshold])>=200000 then 'Customer with Greater than $200K'
elseif sum([threshold])>=100000 then 'Customers with Greater than $100K'
Hope this helps!
Thanks for the feedback.
How would I display Sales in the following assuming I only want to show the names of customers exceeding $200K.
Other (totals all other customers in Region A)
Other (totals all other customers in Region B