2019 Leavers with salary

Summary

OTBI report needed showing 2019 leavers & salaries

Content

Hi,

I have been looking through the shared reports centre and previous posts and haven't really found a suitable

solution to my requirement which is a standard report showing leavers from 2019 and their last salary.

I have so far used "Compensation - Salary History Details Real Time" (see attached XML) but that brings back multiple lines for employees even though I've filtered on 'Inactive' Assignment Type.

Can anyone help on this please? 

Many thanks,

Andrew

Version

19D

Code Snippet

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Compensation - Salary History Details Real Time"">
      <saw:columns>
         <saw:column xsi:type="saw:regularColumn" columnID="c45149a67ffd53e19">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c5171db2cf12648bc">
            <saw:columnFormula>