1 Reply Latest reply on Oct 10, 2012 5:38 AM by frederic.sauvage

    Filter a field with another field

      Hi,

       

      I divide my problem in several little problems and, since the beginning, I have a problem.

      I try to filter a field with another field.

       

      This is the kind of data that I have :

      IDUser_AUser_BWinnerAmount
      112110
      212111
      315525
      423212
      521135
      651510
      75111
      86262
      985525
      1028810

       

      Before trying to have the average amount where Winner=User_A, I would like to do only a filter "Winner=User_A" but I don't success (error about aggregation, about unique field, ...).

       

      Could you explain me the process please ?

       

      Thanks you