Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Perhaps this?
Load distinct [Transaction number], [Copies sold], Sum(Provision) as Provision Resident Table Group By [Transaction number], [Copies sold];