Field filter variables showing all values from a table colum reference, how to "Filter the Filter"?

Hi, I’m using a variable filter [[AND {{user}}]] where user is pointing to a table “Users” column “Full name”, thing is each user has a Client ID and i would like to only show, on the dropdown, on my dashboard Users linked to a specific Client ID.

How can i achieve this? I’ve tried [[AND {{user}} where clientID = x]] and other approaches but than the filter stop working like a dropdown allowing text only.

Hi @Augusto
Sounds like you’re looking for remapping:
https://www.metabase.com/docs/latest/administration-guide/03-metadata-editing.html#remapping-column-values