4 Replies Latest reply on Jun 9, 2016 6:24 PM by Lian Norliansyah

    Removing duplicates (shared members) when calculating top of hieararchy

    Lian Norliansyah

      Hi,

       

      I would like to create a report which user can drill down and drill up (using filter - show relevant values).

      The issue is that there are duplicates members at the bottom level.

      The objectives is that when user select the top of the hierarchy, it should only show the sum for the

      top of the hierarchy after removing the duplicates (shared members).

       

      Here I attached an illustration of what I want to achieve.

       

      Please advise how to do it, as I'm still new to Tableau and lots to learn.

      Your help is kindly appreciated.

       

      Duplicate Data Issue.png

       

      Duplicate Data Issue - Head of Department.png

       

      Duplicate Data Issue - Sub Dept B.png