6 Replies Latest reply on Feb 4, 2019 3:29 AM by Ramandeep Mastana

    Calculate % of total

    Ramandeep Mastana

      Hi All,

       

      Not been able to find a solution for my issue in the forums.

       

      I have a table which I would like to work out the percentage of total for each group, not sure how to go about doing this?

       

      For each department listed I have a list employees that have been certified or expired. I want to calculate the percentage for each of these groups.

       

      Please find attached my worksheet.

       

      Thank you in advance for any assistance.

       

       

      Hoping to get the below output:

       

      DepartmentCertifiedCertified %
      ExpiredExpired %
      SB Operations and Service (OST)624%312%
      Sky Business Senior Management (OST)28%14%
      SB Compliance (OST)28%
      SB Sales Performance (OST)14%14%
      Sky Business Marketing Comms (OST)28%
      Sales Force (OST)312%14%
      SB Field Sales (OST)28%14%