month wise comparison

Hi All,

I am having trouble solving a requirement.

Attaching a sample data.My requirement is:

To show count of sales month wise

however month should be max of order date i.e M and then M-1(Month prvs) till M-3 and rest should fall under M-4.

Like this:

Thanks