2. Parts: this describes the possibilities of what each part will fit
Fields: Part_Number, Make, Model, Year, pk_parts
So, the thing is that I would like to analyze the amount of sales by the different car criterias. I've thought of approaching this by multiplying the sales of each part# by the ratio of the count of the specific criteria to total count to find the sales per criteria.
In the end I would like to find out how much of my sales for the specified year was for a certain Make and/or Make