I want to make a new data set that only shows ID (sorted by ID), the transaction
number, and the total sale for each transaction.
I think I need to first merge the two data sets by Part_no so that I can
compute to total sale, but I'm having trouble with what to do after this to get the proper dataset.
Any help would be much appreciated!