A few questions...
1. what's your date format? is that MM-DD-YYYY or DD-MM-YYYY?
2. please explain in English how to get your expected answer. (what does your data mean?)
Another thing... if you post your data like this, so people can play with it without having to build it themselves, post it like this:
SELECT '01-01-2012' AS SomeDate, 'ABC' AS Field1, 10 AS Value1, 15 AS Value2, 17 AS Value3
SELECT '01-04-2013', 'PQR', 7, 80, 65
SELECT '01-05-2014', 'XYZ', 15, 25, 77;
If you do that, you're far more likely to get tested code in response to your question.