How to select a fieldvalue with another fieldvalue

[Frédéricdh]

I have two fields in my sql selection.

On field shows if the count must be in tonnes or in piece and the other shows the unit.

I want to pilot a listbox formed with the unit field, with the type of count. How can select the value in the listbox with the type of count?

[HirisH_V7]

Can use get field selections and pass it into the setanalysis and use it. Some thing like below. If not elaborate your issue.

Sum({<Year={'$(=getfieldselections(Other Field))'}>} Sales)

[Frédéricdh · Accepted solution]

I found a solution with a button and an action: "Select in field"