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



      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