I would like to get a filter on a column of a table against the value (Ref) of another column of this same table.
In table 1 I have Key + two columns
In table 2 I have too Key + two columns
- Columns “Client/BSI” = Ref ==> Table 1 [Nom Société]
When I select my client, I want only the affiliated subsidiaries to appear in column 2
For the “Subsidiary” column I tried the following formula but it does not work because it shows me all the values, regardless of the “Client / BSI” selected
I tried other formulas referenced in tutorials but they don’t work either.
Could you help me please?
thank you so much