2 Replies Latest reply on Oct 19, 2018 8:54 AM by Ankit Bansal

    create a primary key by field

    ni tempe

      I have data as below

      I have repeat values in employee field.




      employee age division project

      A 5 accounts x

      A 5 accounts y

      A 5 accounts z

      B 10 HR x

      B 10 HR y



      How could I create a secondary key (count rows where division and employee are same) as below. I want to find average age by division and count of employees by division. I am thinking that I will filter data by secondary key = 1 and then do my calculations. Let me know if there is a better way to do the same



      employeeagedivisionProjectsecondary key