BusinessObjects Board

Webi help: Sum only unique records from different queries

building reports
#1

HI all,

I have 4 different queries, lets say for 4 different products’ categories.
Each query can return a product already returned by the other queries (each product has an ID)
I need to create a summary with the total value of the products but avoiding the double counting from the different queries.
Thank you so much for any suggestion!!!

#2

Welcome on board - sounds a bit too abstract to give you a definite answer.

Do they fully overlap?
For example, would Product A from Q1 have the sale total as the value for Product A from Q2?