This content has been marked as final. Show 4 replies
I have data file looking like this:
There are 4 different SalesID (250 - 450 - 100 - 800). Now I like to calculate how many pieces of product AA10 has SalesID 250 sold but deducted all the products which has been resold.
'SalesID 250' has sold 10 items of AA10 to 'BuyerID 450' - but 'BuyerID 450' has resold 2 items of AA10 to 'BuyerID 900':
The calculate figure should be 8 (10 - 2)
'SalesID 250' has sold 5 items of AA10 to 'BuyerID 300' - and 'BuyerID 300' hasn't resold any items of AA10
The calculate figure should be 5 (5 - 0)
Any suggestions how to calculate this ?