Skip to main content

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 A1Customer B2Customer C1Customer D1Customer A2Customer B1Customer A3Customer B1Customer A2Customer B1Customer A1Customer B1Customer E1Customer E1Customer E1Customer F1Customer G1Customer I1Customer J1Customer K10Customer C1

 

Thx

4 answers
  1. Aug 9, 2017, 4:05 AM

    Hi Guru,

    Just Drag this Calc to the filter and SET TRUE.

    Thanks

    Deepak

     

    Hi Guru,Just Drag this Calc to the filter and SET TRUE.

0/9000