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

Merged queries shows wrong Sales amount

105 Views

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!!

Attachments

webi-issue.jpg (339.0 kB)