1 Reply Latest reply: Jul 25, 2017 6:37 PM by Antonio Mancini RSS

    Max of another dimension of every single value loaded

    Omar Pennacchio

      <simple question>

      I am loading data from various tables.

      I have 2 tables which are associated through Contact name.

       

      Customer nameContact name
      APeter
      AMike
      AJohn
      BPaula
      CPaul

       

       

      Contact nameScore
      Peter80
      Mike100
      John120
      Paul10
      Paula10

       

       

      When I select this data I would like to create a Max Score for every Customer name.

      Any clue/hints is highly suggested?

       

      Customer nameMax Score
      A120
      B10
      C10

      </simple question>