6 Replies Latest reply on Oct 12, 2017 3:51 PM by Deepak Rai

    Count Distinct Value changes when ID column is removed

    Sam R

      HI All,

       

      I need some help in the attached workbook. I am trying to achieve a count distinct of Ids for a particular group. When i have the ID in the rows the count distinct count is correct (Sheet 1) . However when i remove the id row column, the overall count changes (Sheet 2). Not sure why that is happening. Also, is there a way i can include the 2 filters inside the calculated count column as i need to combine it with other columns which should not be affected by these particular filters.

       

      Thanks

      Sam