Comparing current Job Titles to previous week Job Titles in OTBI
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.
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".