16 Replies Latest reply: Jan 27, 2012 8:19 AM by María José Serrano RSS

    Min value by two dimensions

    María José Serrano

      Hello,

       

      I'm having a problem in retrieving the min value by two dimensions.

       

      I mean I have this data structure

       

      ProductSupplierAvg Price
      A11.5
      A20.8
      A32.1
      B13.2
      B24.2
      B33.8
      C17.1
      C28.2
      C36.9

       

       

      and I need to obtain for each product the supplier having the min average price, that is to say:

       

      ProductSupplierAvg Price
      A20.8
      B13.2
      C36.9

      I've tryed a lot of combinations with min and aggr functions but with no results.

       

      Can anyone help me?

       

      Thanks in advance,

       

      MJ