I'm having a lot of performance when applying row level security using a calculated field: example being:
( [Seurity Sales Team] = "AMS Canada" AND ISMEMBEROF ("Team - AMS Canada")) OR
( [Seurity Sales Team] = "AMS Digital Safe" AND ISMEMBEROF ("Team - AMS Digital Safe"))
The field has a lot of groups and is causing the workbook to render really slow.
Has anyone come across this before?