I have a list that exceeds the 5000 item limit. I created a view that is limited to 500 total items returned but I still get the error:
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
There are no lookup columns on this view. What could be the cause of the threshold being tripped?