2 Replies Latest reply on Nov 13, 2018 1:25 PM by maneesh.gaddam

    Need help with capturing the no of clients who have used one service, two services, three services...and so on

    Sonnie Chen

      I have a list of projects submitted by various clients under various service lines

       

      Sample date will look like below:

       

         

      Client
        Name
      Project IDService LineAmount
      AdrianPJ1000Translation2206
      SuzannePJ1001SharePoint services813
      GeorgePJ1002Document  & Design317
      TimPJ1003Translation195
      KingPJ1004Robotics Automation857
      GabriellePJ1005Survey1615
      VijayPJ1006Translation454
      AdrianPJ1007Robotics Automation1356
      NicholasPJ1008Research100
      TamiPJ1009Research779
      LisaPJ1010Research775

         

      I am trying to capture the no of clients (unique) who have used one service lines, two service lines and so on.

       

      Below is what I could achieve.

       

       

      What I am trying to create will look like below.

       

      Can somebody help me here

       

      Attached is the packaged workbook

       

       

      No of
        service lines used
      No of clients
        (unique)
      PercentageNo of Projects
      1
      2
      3
      4
      5
      6
      7
      Grand TotalX100%