Filter object filtered in a sheet not in the other

[noemibuscemi01]

Hi,

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 from the selection the ID values being part of the captive network, else show the ID field related to the network).

[noemibuscemi01 · Accepted solution]

I've found a solution on my own:

aggr(only({$<[MR.Network] <> {'Network Captive'}>}[MR.ID]),[MR.ID])