select
FiscalYear
,FiscalQuarterOfYear
,FiscalMonthOfYear
,FiscalWeekOfYear
,CustomerGroupId
,OrderTypeGroupId
,sum(NetAmount) over (
partition by CustomerGroupId, OrderTypeGroupId, FiscalYear, FiscalWeekOfYear
order by CustomerGroupId, OrderTypeGroupId, FiscalYear, FiscalWeekOfYear
rows unbounded preceding) WeeklyNetAmount
,sum(Units) over (
partition by CustomerGroupId, OrderTypeGroupId, FiscalYear, FiscalWeekOfYear
order by CustomerGroupId, OrderTypeGroupId, FiscalYear, FiscalWeekOfYear