Comparing current Job Titles to previous week Job Titles in OTBI
Summary:
Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports as I would like to schedule this report on a weekly basis to the Requestor.
Content (required):
I'll need to set up a report that lists employee's in a department with their current Job Title and in an adjacent column the Job Title they held in the previous week. I'll be creating a custom column at the end that lists three values "No Change", "Job Change" and "New Starter".
Tagged:
0