Sales by year

1 view
Skip to first unread message

Santosh Gadila

unread,
Nov 15, 2011, 2:37:05 PM11/15/11
to ccs...@googlegroups.com

SELECT

     st.SalesTerritoryGroup,

     st.SalesTerritoryCountry,

     d.CalendarYear,

     SUM(s.SalesAmount) SalesAmount

FROM

     dbo.FactResellerSales s

     JOIN dbo.DimDate d on d.DateKey = s.OrderDateKey

     JOIN dbo.DimSalesTerritory st on

     st.SalesTerritoryKey = s.SalesTerritoryKey

GROUP BY

     st.SalesTerritoryGroup,

     st.SalesTerritoryCountry,

     d.CalendarYear

ORDER BY

     st.SalesTerritoryGroup,

     st.SalesTerritoryCountry

Reply all
Reply to author
Forward
0 new messages