I am trying to Create user filter with hierarchy data
Currently I understood from the following link on how to setup the data and create user filter
I need to setup user filter from Region to City level drill down automatically.
I can achieve it with manual user filter creation however we have almost 1000+ users which make the job tedious.
Attached sample data for reference please see "people tab" where I am planning a similar setup and how will I able to set the data to avoid duplication.
Also have a situation where few managers need access to all the data.
Having multiple columns will not work as mentioned in the link above as I have many users