I have a sharepoint list with 20k+ records. I'm using the ID filter to get the records where ID is less than 1,500. I know ID field is automatically indexed so I should have only 1,500 records returned in my view, but if I add another filter after the first one then I receive the error that list view threshold has been reached. Why is that If with the first filter I'm sure i'm only getting the first 1,500 records?
Project:Region is a lookup column: