Good day , I have a field which list all deductions and earnings for a companies Payroll.
I designed a report for the company and I need to separate the data in the one field into 2 subreports or list all deductions on the right and earnings on the left. i have already tried a conditional formula to say if is like any earning do not show on deductions side. Here is an example of what i want to accomplish

here is the values from that field.

Regular
Holiday Pay
Bosl ( bank charges)
PAYE (Pay as you Earn)
National Ins.
Other Deductions
Service Charge
Tips
Overtime
Cash Advance

I would like these values which are all generated from one field to be placed into two subreports or fields.

1.
Earnings:
Holiday Pay
Regular
Tips
Overtime
Service Charge

2.
Deductions:
Cash Advance
Other Deductions
Bosl (bank charges)
Paye (pay as you earn)
National Ins.

i have been working on these for a month now , any help would be greatly appreciated.

Regards,
Teddy