with sales as (
select CustomerId, CalendarDateId, sum(TransactionAmount) Amount from dbo.Sales group by CustomerId, CalendarDateId)
select customer.Name, calendar.FiscalYear, calendar.FiscalWeekOfYear, Amount
from sales
inner join dbo.Customers customer on sales.CustomerId = customer.Id
inner join dbo.Calendars calendar on sales.CalendarDateId = sales.CalendarDateId