8 Replies Latest reply: Apr 2, 2012 10:04 AM by jaivikpatel RSS

    Top 3 Averages

      Hey could someone help me with an issue i have got,

       

      I have 7 feilds :

       

           ResponseID,

           Region,

           LotusNotes,

           SAP R/3,

           MSOffice,

           VPN,

           VideoConferening,

       

      Where LotusNotes,SAP R/3,MSOffice,VPN and VideoConferencing are applications which are rated from 1-10.

      ResponseID is an ID given to each individual that has rated an application.

      Region relates to where the individual is from.

       

      I need the applications to be sorted by top 3 averages , but then if the filter Region was selected it would change the averages according to that Region.