11 Replies Latest reply: Aug 6, 2012 5:38 AM by Daniel Garguilo RSS

    Help: Criteria? Set Analysis? Across records

      Hi All,

       

      Is there any way to set up a filter criteria that would go across all records for a person? IFor example, in the table below is it possible to select the sales person where in any Month Sales Activity was >100 and also in any month Sales Income was <£10,000. John would meet this criteria as in Months 1 and 2 Activty was > 100 and in months 4, 6 and 7 Sales income was <£10,000. Tom would not meet the criteria as at no point was Sales activity >100.

       

       

      PersonMonthSales ActivitySales Income
      John1100£10,000
      John2120£20,000
      John380£30,000
      John490£4,999
      John534£34,000
      John680£4,566
      John780£9,000
      Tom178£1,000
      Tom267£40,000
      Tom387£34,000
      Tom498£56,000
      Tom587£23,000
      Tom656£3,000
      Tom745£4,000

       

      Any help woudl be great.

       

      Thanks

       

      Dan