Load correct sale

[Hauglaen]

Hi,

I have a problem with incorrect copies sold on transaction level when there are more than one seller on the sale. 

Example:

Transaction number	Seller	Copies sold	Provision
100	Person 1	1	5
100	Person 2	1	5
100	Person 3	1	5
120	Person 1	5	37,5
120	Person 2	5	37,5
150	Person 1	10	150

The above example should look like this:

Transaction number	Copies sold	Provision
100	1	15
120	5	75
150	10	150

Is it possible to solve this in Date load editor?

[Anil_Babu_Samineni]

Perhaps this?

Load distinct [Transaction number], [Copies sold], Sum(Provision) as Provision Resident Table Group By [Transaction number], [Copies sold];