Employment Position History Report

Summary

Grouping data

Content

I am creating a BI Report that basically lists out all the Jobs an employee has had during their employment, so of course my initial grouping is EMPLID. (Sample XML File is attached) My issue is that if an employee starts with JOBCODE1, goes to JOBCODE2, then back to JOBCODE1 and then JOBCODE3 the report has to put out 4 lines. In addition the report needs to calculate the length of time in each position. It does this by using the EFFDT from the first line of each JOBCODE and the EFFDT from the last line of the JOBCODE calculate