Auto Filter does not reflect Set Criteria

Auto Filter does not reflect Set Criteria

Hi,

I have a dropdown field "Shopping Centre". This field is linked to another form which contains names of all shopping centres, as well as the owner of the centre. The "Shopping Centre" field has a criterion set "Owner == 'Owner1'", since I only want the dropdown to show names of reviewers who belong to Owner 1. Now when I add this "Shopping Centre" field to the auto filter in a View, when I try to filter while accessing the View, I can see all Shopping Centres, not just those owned by Owner1. This creates an issue for us since we do not want the owners to see what the other owners have.

Because the list has been pre-filered by the Set Criteria, the auto filter should only shows choices which satisfy the report Set Criteria. Is this a bug?

I found an old Topic which cover this issue but it seems there are no solutions yet. The link is:  https://help.zoho.com/portal/en/community/topic/auto-filters-should-respect-quot%3bset-criteria-quot%3b
Can anyone provide a solution for this issue?

Kind Regards,
Pambudi