Remove columns you don't want to group on.

>Thanks Sergy. You are amazing! That gets me to here.
>

>select crsB.category, jul, [fisyear]
>from (select distinct category from [RTA-Revenues]) as crsA 
>inner join (
>select [fisYear], [category],
>CASE WHEN month([receiveddate])=7 THEN sum(AMOUNT) ELSE CAST(0 AS numeric(12,2)) END as Jul
>from [rta-revenues]
>group by receiveddate, FISYEAR, CATEGORY) as crsB
>on crsA.CATEGORY = crsB.CATEGORY
>order by FISYEAR
>

>
>Note that sqlserver is insisting on having receiveddate in the group by clause. Something I did not have before. As above it runs but produces multiple rows for each fisyear/category combination. Something I do not want.