maybe something like this will help ?
SELECT Customer,
MAX(case when YEAR(ReceivedDate) = 2014 then 1 else 0 end ) as thisyear,
MAX(case when YEAR(ReceivedDate) = 2013 then 1 else 0 end ) as lastyear
FROM TransData
GROUP BY Customer
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day