I have a report with 14 column's with detail filters applied. Please see the image attached.
Detail Filter's Applied- Scheduled end >= '2017-07-01'(Coloumn no 8 in pic), Start Date <= '2017-09-30' (Coloumn 9 in pic), Date between 2017-07-01 and 2017-09-30(Coloumn 10 in pic)
Report gives me Total Pay hours of candidates, however I wanted
Requirements-
Based on column 12 i.e Coming month first date
Candidates whose coming month first date is 08-01-17 there pay hours should only be calculated in between 08-01-2017 to 09-30-2017
and
Candidates whose coming month first date is 09-01-17 there pay hours should only be calculated in between 09-01-2017 to 09-30-2017
Please guide/help me how to do it. Thank you