select a value and select the same value in another field

[beck_bakytbek]

Hi Folks,

i got a question, my table does look like:

Project, Shipment, InvoiceDate, Value

A, 2021, 2020, 50

B, 2020, 2021, 25

my question, is that possible select the certain value and the same value in another field: my expect output is:

if i select the Year within Field: Shipment = 2021, so i want to have the value = 2021 in the field: InvoiceDate = 2021.

Does anybody have any idea how to rectify this issue?

Thanks a lot