Select Excluded, even when a value is selected

[crystles]

I need to be able to have a button or chart that displays all the Excluded values of a selection, EVEN when one of them is selected.

I have a map with States. Customers are associated to each state, with some states having more than one Customer.

When they have a state and customer selected, I still want to be able to display the other Customers that are associated with the state.

So say California has 3 customers.

Customer 1

Customer 2

Customer 3

When Customer 2 is selected, I want to display the other two Customers (1 & 3) so the user can then select the other customers. If they want to switch between the other customers associated with the state, they can then select one of the other Customers specific to that state. Say they select Customer 1, then only 2 & 3 would be showing, etc.

Any help would be greatly appreciated.

[crystles]

I am so sorry, I feel very dumb. This does work.I have the state selected but I didn't have a dealer selected.

It works when you select a dealer. I used this formula before and just assumed it wasn't working. But I didn't have the dealer selected so of course it wouldn't work.

Thank you so much for your help! This worked perfectly.

I should have had more faith in myself to begin with