6 Replies Latest reply: Jun 15, 2011 7:01 AM by Deepak Kurup RSS

    count distinct

      I have a set of data with the following info:

       

      MEM#, FV_GROUP

      123      FV

      456      FV

      753      NFV

      963      FV

      456      FV

      769      NFV

       

      I like to get a distinct count of the MEM#.

       

      The result, I like to see is

       

      FV has a count of 3

      NFV has a count of 2

       

      The expression I have right now is

       

      =count(distinct(MEM#))

       

      How can change the expression so that I can check the FV_GROUP.

       

      Thanks.