Here's a start for you. The approach I've taken is to create a calculated field on a per-brand basis that figures out if said brand has sales or not. I only created fields for brand A and B ("Carrying Brand A", "Carrying Brand B")
Those "per-brand" calculations can then be knitted together in a different field ("Color Chooser") to display different values (which drive color) based on the output of the "Carrying Brand ?" fields.
I also used a parameter to allow the user to choose WHICH brand he/she is interested in seeing. It's called "Choose a Brand". For fun, I included a field "Sales Sizer" which is used to drive circle size - If a brand has no sales it returns the number "1", else it returns the actual sales for that brand.
Not_Carrying.twbx.zip 96.7 KB