Skip to Content
Jan 11, 2019 at 06:55 PM

Merged queries shows wrong Sales amount


Dear community,

I prepared a draft of what I need. Hope it is clear what I want to calculate.

I have two queries which I want to merge. Actually I alread merged the queries by merging through REF2. Now I want to show the Sales from Query2 in Query1 but I get total sum of all data for each row in Query1.

Which formula do I need to solve this issue?

Thank you!!


webi-issue.jpg (339.0 kB)