Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear community,
I would like to have a selected value filled on a sheet and several different tables.
The selected value must change a selection in another field with a non-identical heading.
I would like to change the selection in another table at the same time as selecting the work name. Here, the selection of the plant name should simultaneously adjust the goods recipient, so that the user only has to make one selection.
How can I imagine the code for this.
Is it possible?
I do not know how to do this.
thanks in advance.
best regards
Maik
Hi,
I think you should be able to use P() function & set analysis, so on the table you filter on the other field use something like {<[Plant Name]=P({$} [Work Name])>} as the set (you may need to either use {1} instead of {$} or cancel the selection on [Work Name] by using [Work Name]= in your set depending on your data model and how you want it handle other selections).
Result something like this;
Cheers,
Chris.