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




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