1 Reply Latest reply on Jan 24, 2019 6:53 AM by Paul Wachtler

    Possible to narrow down actions by specific person, not including actions by direct reports

    mina cosentino

      Hi there! I am pretty new with Tableau, but am trying to figure out how to solve the below. Unfortunately I cannot upload a workbook due to confidentiality issues.

       

      What I am trying to show is the SE (Leader), the number of people on their team, and the number of actions they as a leader have taken (not the sum of actions between themselves and their direct reports). The problem is I cannot filter on their role as a leader (dimension role group = SE) because then it does not count their team size properly. Is there an easy way to achieve what I am trying to do? All help is appreciated.

       

      Screen Shot 2019-01-24 at 09.09.41.png