Report to show "Previous Incumbent" name in an existing "Position Incumbent Report"
We have an existing "Position Incumbent Report" in which we show the "current incumbent" name. But now we have a requirement to add a new data column as "Previous Incumbent" to this existing "Position Incumbent Report" to show the Person name of the employee who occupied this position previously (just before the current incumbent and not all other historical ones). We need this "previous incumbent name" in the data model that has already been built. How do we add to it?
On Position Details screen-> On Current Incumbent, We do see the data such for Position Entry Date and Position Exit Date with historical data. But not sure, how to use these data points to show in our existing report data model as per the requirement mentioned above.