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