Is this possible through Set Analysis?

[Anonymous]

Hi everyone

I have the following data model where I have a list of Products sold and a field where it is indicated if a product was sold as result of a devolution from other:

Product	Returned Product	#Packages
Product A		1
Product A	Product B	2
Product B		5
Product B		3
Product C	Product A	7

I want to achieve the following result:

Product	Sales	Returns
Product A	3	7
Product B	8	2
Product C	7	0

Is this feasible through set analysis?

Many Thanks for your support.

[Anonymous]

Thanks,

With this aproach I was able to get the result.