Hi, as we need to recreate every one of our reports as a story report... I am having some difficulty building out an events report that shows what the employee detail was before the effective date of the change and what was after.
So if an employee moved from business analyst to Sr Business analyst ... I want to see both Kind of like the below.
| Employee # | Effective Start Date | Type | Change from - Position | Change to - Position | Change from - Business Unit | Change to - Business Unit | Change from - Manager | Change to - Manager |
| 123 | 6/1/2024 | Promotion | Business Analyst | Sr. Business Analyst | Personal Finance | Financial analysis | Bill | Sally |
\Does anyone know how I could do that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.