4 Replies Latest reply on Jun 10, 2018 10:50 PM by Jyothi Hegde

    Distinct count of multiple columns

    Jyothi Hegde

      I have a report that includes different columns of data. The columns have duplicate data.  For each provider in column 1, I would like to get a distinct count of other columns (age groups ) based on the customer column. Below are some of the columns of the report.

       

      Example:

       

      Provider
      customer
      age group 1
      age group 2
      age group 3
      AAZZ1
      AAZZ1
      BBYY1
      CCMM1
      CCNN1

       

      The summary report should look like -

       

      Provider
      distinct count(Age Group 1)
      distinct count(Age group 2)
      distinct count(Age Group 3)
      AA1
      BB1
      CC2

       

       

      Any insight into this would be greatly appreciated.

       

      Thanks in advance.

       

      -JH