1 Reply Latest reply on Mar 1, 2017 3:37 PM by diego.medrano

    Need help with hierarchy data user filter

    tableau gstl

      Hi All,

       

      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

       

      https://www.interworks.com/blog/anonymous/2013/04/05/tableau-qa-row-level-security

       

      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

       

      Toby Erkson

       

      Regards