What filter can I use to only list the Last Assignment details for employees and not duplicate rows.
Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, it currently duplicates rows and the Assignment number is blank on the second row. I only need to show the latest row. Also, Rehire date is needed. Is there a known filter or field I can use? I tried to use "Primary Assignment - Yes", but that did not work, as it still duplicates rows. Thanks, Roland
Content (required): Standard Report listing Assignment Details in Oracle Transactional Business
Version (include the version you are using, if applicable):