6 Replies Latest reply on Jun 10, 2016 12:19 PM by Ivan Young

    Sum of COUNTD when drilling up in hierarchy?

    John Conlon

      Hi,

       

      I'm having trouble summing a distinct count when I drill up in a hierarchy within a table.  I have attached a workbook with an example.  At the lowest level of the hierarchy I want a Count(Distinct) of the ID field, which is what I have done in the workbook.  However, when I start drilling up in the table I just want a simple sum of the distinct counts, but what I get is a roll up of distinct counts.  For example, the distinct count for "Finance | acquisition | Direct Ad | trip1" is 5 and "Finance | acquisition | Direct Ad | trip2" is also 5.  When I drill up a level I want to see the sum of 10, but instead I get the distinct count of 5.  Any suggestions would be much appreciated.

       

      Capture.PNG

       

      Thanks,

      John