Hi,
Need help to achieve below output in WebI.
Query A

Query B

Expected Output:

My requirement to pick Target from Query B based on Sales Date from Query A, where Sales Date falls between Start Date and End Date.
Common object : User Id
have tried this formula but getting multivalue error.
=[Target] where ([Sales Date] between ([Start Date];[End Date]))
Thanks in advance!