show variable parameters in differnt Tables on a Dashboard
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.
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).