0 Replies Latest reply on Jul 15, 2013 12:42 PM by LalaLove

    Help Designing Parts and Sales DB

    LalaLove

      Title

      Help Designing Parts and Sales DB

      Post

           Hello,

           I have two sets of data:

           1. Sales: the amount of sales for each part# by year

           Fields:  Sales_Year, Part_Number, Sales_Amount, pk_sales

           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

            How do I approach this?