Making a Subtotal Deviation If aka Doing a Deviation If with filter

[Althero]

Alright so I have a chart in which I need to do some deviations with a single criteria.
Problems is the filtering involved and therefore subtotal, sumproduct and other complicated functions are involve.

Here is an excel chart I just made to illustrate my dilemma.
http://s3.pdfconvertonline.com/convert/p3r68-cdx67/buzb6-izusp.html

Plz save my bacon guys. I just spend the last hour of my shift trying to make this work and I don't spend tmr doing this.