Jef - Before I understand the requirement. I have couple of questions...
1. how did you arrive amount as 120 . Your excel file does not show up any amount or quanity to calculate the amount.
If I select the month May, I want to see : Sales amount 0 + 120 + 210 + 30 = 360 (because line1 of order AAA is cancelled in May, and line 2 is only cancelled in September)
2. You wanted to exclude the canceled amount right? Let's say for example the first row order is placed in May but cancelled in September. So what do you want to see when May, June, July & August are selected?