4 Replies Latest reply: May 11, 2015 8:07 PM by Marco Wedel RSS

    Relationship between tables

    Alexandre Lourenço

      Hi all.

       

      I'm trying to solve this problem.

       

      How do I cross the tables below to calculate:

       

      Full potential of 2015

      (Answer should be 800)

       

      or Full potential by product

         (Answer should be A = 3700 ; B = 300)

       

      Tks a lot!!

       

      Sales per Year

      CityCódYear of ProductionQtd
      São Paulo120155
      Rio de Janeiro120143
      São Paulo220147
      Rio de Janeiro3201310
      Rio de Janeiro620155

       

      Models

      CódProduct
      1A
      2A
      3A
      4A
      5B
      6B
      7B

       

       

      Potential of maintenance

      ProductYearPotential
      A2015100
      A2014150
      A2013170
      B201560