Hi Antonio

this is an amended code from what you suggested.

===

SELECT YEAR(DATEADD(month, - 1, ShiftDate)) AS fiscal_year, SUM(CASE WHEN month(ShiftDate) = 7 THEN TotalHrs END) AS Jul,...

Hi folks

thank you for your patience, i've managed to run the code now without any errors. the result set returned by the grouped query is:

In columns > fiscal_year then Julhours...

Hi, thank you for your replies.

i tried antonio's grouped query suggestion but i rec'd an error 'invalid column name TotalHours'

this is what i did, i created a new View in...