Query Calculation not sure how to do. Please help me

[ankur10]

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