Multiple lines in story report for compensation

[ishaqyousuf]

Hi community members

I am creating 1 story report to provide what are the payments in Recurring pay components for an employee for last 2 year for "medical" pay component only.

I started with Job info (time filter as of date) and join Compensation table. I can see the following outcome

Person ID External	Pay Component (comp)	Effective Start Date (Compensation)	Effective End Date (Compensation)	Amount
2	Medical Insurance Ded	1-Sep-23	30-Sep-23	-17
2	Medical Insurance Ded	1-Oct-23	21-Jan-24	-24
2	Medical Insurance Ded	22-Jan-24	23-Jan-24	-24
2	Medical Insurance Ded	24-Jan-24	31-Dec-99	-28

Now functionlly, amount "-24" is in comp from 1 oct to 23 Jan 2024 so there should be 1 record. System is showing 2 records because something else is change in comp table but we want to bring comp records Only if the amount is changed. SO how can i achieve the following outcome 

 Earliest start date and latest end date should come if amount is continued.

[SayadAdil]

you can use cross table to get one row for your data