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.
| Person | Month | Sales Activity | Sales Income |
| John | 1 | 100 | £10,000 |
| John | 2 | 120 | £20,000 |
| John | 3 | 80 | £30,000 |
| John | 4 | 90 | £4,999 |
| John | 5 | 34 | £34,000 |
| John | 6 | 80 | £4,566 |
| John | 7 | 80 | £9,000 |
| Tom | 1 | 78 | £1,000 |
| Tom | 2 | 67 | £40,000 |
| Tom | 3 | 87 | £34,000 |
| Tom | 4 | 98 | £56,000 |
| Tom | 5 | 87 | £23,000 |
| Tom | 6 | 56 | £3,000 |
| Tom | 7 | 45 | £4,000 |
Any help woudl be great.
Thanks
Dan
