I have a statistics table outputting resellers, their id,purchases and amount.
Eg.
ID - Resllers - Purchases - Amount
101 - ABC - apples - 20
101 - ABC - oranges - 10
303 - DEF - apples - 5
303 - DEF - oranges - 1
Since the Resellers can differ but with...