4 Replies Latest reply: Jan 19, 2018 8:28 AM by nagarjuna reddy RSS

    How to get count in no of meetings based on metting id(Meeting Id have Duplicate)

    nagarjuna reddy

      Hi Experts...

       

      How to get  No of meetings and Rank  below the my source file

       

      Based on the client we need count of no of meeting?

       

      Meeting Id

      Event DateEvent TypeMeeting Type CodeClient NameProduct Line
      161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares               
      1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares         
      Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
      161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares               
      1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares               
      1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
      1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares   
      1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares           
      1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares           
      1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro Shares