Hi all,

I have multiple pivot table reports that have the right metrics I need (using Zoho Creator).

However, I need to filter the data based on the user that's logged in.

I have a lookup form that can identify what locations (for example) each user can see. Right now the only way to customize what user A vs what user B can see is by having multiple pivot table reports, pre-filtered to what that user can see. This is getting unmanageable and not scalable. Any workarounds? 

Thanks!