Hello,
Can anyone please help me out for following issue ?
Thanks for your time to look on..
Hello Dipti,
Item level permissions seem to be the source of your problem then. I suppose that SharePoint has to scan the entire list in order to determine permissions, before even grouping by the indexed column, thus hitting the threshold.
Unfortunately, you’ll have to either remove the item level permissions or increase the list view threshold for your view to work.