I have two sheets (dealer and agents), when I filter a filter object in dealer I don't want the selection to affect the agent sheet. How can I do that?
I want that
if (network = 'captive', exclude values being part of the captive network, else show the related ID field).
