7 Replies Latest reply on Jun 8, 2016 4:25 PM by Luis Amadeo

    displaying the the result of one filed with the associated row from another field

    Luis Amadeo

      We are kind of stuck on this one. We would like to display the maximum employee id with the corresponding employee status and get the total count. So in the image attached, the max employee id of 36834 that is associated with # 2 employee status would display in one row for each employee. I created an LOD expression that gives me the max employee id (don't know if I needed to do this, there could be a simpler solution). Can't post the actual workbook. Just hoping that the image is self explanatory. Essentially, the data is that each employee has several employee ids and each of these can have an associated employee status. We want to count only the records with the max employee id and the associated employment status for each employee.

       

      Thanks

       

      Luis