6 Replies Latest reply on Oct 19, 2017 6:57 AM by Kostis Gkikas

    Subcounting members of Sets

    Kostis Gkikas

      Hello guys,

       

      I have a variable called Names and a variable called Departments.

      What I want is to divide the variable Names into 3 different groups and get the total subcount of the departments for each of these groups.

       

      This means that I wat to divide Names into group A: {John, Paul, Antony} and get the total nuber of Departments that all John, Paul and Antony have.

      The easy way to do that, would be something like: COUNT([Departments]) IF [Names] in A.

      However, I can not find a way to do this in Tableau.

       

      Any help would be greatly appreciated.

       

      Thank you.