2 Replies Latest reply on May 2, 2013 4:20 PM by Jean Francois Carton

    Select Record when more than 1 record

    Jean Francois Carton

      Hello,

       

      I am trying to show on a map only the records (company) who have more than 1 record.

       

      Company X                    Case 1               Description          Florida

      Company I                     Case 1               Description          California

      Company X                    Case 2               Description          Florida

      Company B                    Case 1               Description         California

      Company A                   Case 1               Description          California

      Company X                    Case 3               Description          Florida

      Company A                   Case 2               Description          California

      Company X                    Case 4               Description          Florida

       

      So the result will be only:

       

      Company A - 2 Cases - California

      Company X - 4 Cases - Florida

       

      And that's it, Company I and B will be exclud.

       

      I used to use Sum(company, count) and Count (ID) for Company with other softwares but I am not sure what to use here.

       

      Thank you!