3 Replies Latest reply: Sep 24, 2015 12:56 PM by Mark Rudolphi RSS

    Data set design - Product vs Market

    Mark Rudolphi

      Struggling with what I think is probably easy so hope there is a solution.  I have two data sets.  They are similar (Date,Price and Scenario) but one is Market and one is Product.  Example is market would be Apple but Product would be Apple Juice, Apple Sauce, etc.

       

      I want to plot the prices for Market and for Product.  Each market relates to certain products. 

       

      I'm a beginner in data design. I cant select a market and product at the same time.  I'm thinking I need another table where Market and Product could intersect?  Like

       

      Market  Product

      Apple     Apple Juice

      Apple     Apple Sauce

      ...

       

      Does that sound right?  Would this allow me to have Market and Product selected?  If no, any ideas on possible solution?