5 Replies Latest reply: Oct 21, 2016 2:43 AM by jagan mohan rao appala RSS

    Distinct Count of two columns

    Elisha Thapar

      Hi,

      I have two columns that have the Employee IDs.

       

      I want to get these three values:

      1. Distinct Employees in Column 1

      2. Distinct Employees in Column 2

      3. Distinct Employees that appear in both columns

       

      The first two are straightforward but I'm struggling with the last scenario.

       

      Please help