3 Replies Latest reply on Aug 9, 2017 8:09 AM by Deepak Rai

    Creating a Set

    Guru Vijendra

      Hi,

       

      Here is my sample dataset and I would like to create a set which will extract only the customer names who have made more than one 'Call'. So i used the condition "SUM([Calls]) > 1" while creating a Set. While this extracts works fine with the sample data set, but it doesn't seem to work with my data with 2 Million rows.

       

      So is this is right way to create the Set for my need? or is there any other method, please suggest.

       

       

          

      Customer Name            Calls
      Customer A1
      Customer B2
      Customer C1
      Customer D1
      Customer A2
      Customer B1
      Customer A3
      Customer B1
      Customer A2
      Customer B1
      Customer A1
      Customer B1
      Customer E1
      Customer E1
      Customer E1
      Customer F1
      Customer G1
      Customer I1
      Customer J1
      Customer K10
      Customer C1

       

       

      Thx