SQLData Source=(local);Initial Catalog=AdventureWorkstruef3057d13-47d2-41db-9154-e016fb9bc828ProductCategorySystem.StringSubCategorySystem.StringOrderYearSystem.Int32OrderQtrSystem.StringSalesAmountSystem.DecimalTerritorySystem.StringRegionSystem.StringDataSource1SELECT
PC.Name AS ProductCategory,
PS.Name AS SubCategory,
DATEPART(yy, SOH.OrderDate) AS OrderYear,
'Q' + DATENAME(qq, SOH.OrderDate) AS OrderQtr,
SUM(SOD.UnitPrice * SOD.OrderQty) AS SalesAmount,
Sales.SalesTerritory.[Name] AS Territory,
Sales.SalesTerritory.[Group] AS Region
FROM
Production.ProductSubcategory AS PS JOIN
Sales.SalesOrderHeader AS SOH JOIN
Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID JOIN
Production.Product AS P ON SOD.ProductID = P.ProductID ON PS.ProductSubcategoryID = P.ProductSubcategoryID JOIN
Production.ProductCategory AS PC ON PS.ProductCategoryID = PC.ProductCategoryID JOIN
Sales.SalesTerritory ON SOH.TerritoryID = Sales.SalesTerritory.TerritoryID
WHERE
(SOH.OrderDate BETWEEN '1/1/2003' AND '12/31/2004')
GROUP BY
DATEPART(yy, SOH.OrderDate),
PC.Name,
PS.Name,
'Q' + DATENAME(qq, SOH.OrderDate),
PS.ProductSubcategoryID,
Sales.SalesTerritory.Name,
Sales.SalesTerritory.[Group]falsefalsefalsetrueProductCategorySystem.StringSalesAmountSystem.DecimalCostSystem.DecimalRevenueSystem.DecimalDataSource1SELECT
PC.Name AS ProductCategory,
SUM(SOD.UnitPrice * SOD.OrderQty)/1000000 AS SalesAmount,
SUM(P.StandardCost * SOD.OrderQty)/1000000 AS Cost,
SUM(SOD.UnitPrice * SOD.OrderQty)/1000000-SUM(P.StandardCost * SOD.OrderQty)/1000000 AS Revenue
FROM
Production.ProductSubcategory AS PS JOIN
Sales.SalesOrderHeader AS SOH JOIN
Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID JOIN
Production.Product AS P ON SOD.ProductID = P.ProductID ON PS.ProductSubcategoryID = P.ProductSubcategoryID JOIN
Production.ProductCategory AS PC ON PS.ProductCategoryID = PC.ProductCategoryID JOIN
Sales.SalesTerritory ON SOH.TerritoryID = Sales.SalesTerritory.TerritoryID
WHERE
(SOH.OrderDate BETWEEN '1/1/2003' AND '12/31/2004')
GROUP BY
PC.NamefalsefalsefalsetrueProduct Categorytruetrue#528ae7BoldWhite2pt2pt2pt2ptSub Categorytruetrue#528ae7BoldWhite2pt2pt2pt2pt1in1in1in1in0.25in=Sum(Fields!SalesAmount.Value)truetrueNormalC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueNormalC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt0.25in=Sum(Fields!SalesAmount.Value)truetrue#c0c0c0BoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrue#c0c0c0BoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrue#c0c0c0BoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrue#c0c0c0BoldC02pt2pt2pt2pt0.25in=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt=Sum(Fields!SalesAmount.Value)truetrueBoldC02pt2pt2pt2pt=Fields!Region.Value0.25in=Fields!Region.Valuetruetrue#528ae7BoldWhite2pt2pt2pt2pt0.25inTotaltruetrue#528ae7BoldWhite2pt2pt2pt2pt=Fields!OrderYear.Value0.25in=Fields!OrderYear.Valuetruetrue#528ae7BoldWhite2pt2pt2pt2pt0.25inTotaltruetrue#528ae7BoldWhite2pt2pt2pt2pt=Fields!ProductCategory.Value1in=Fields!ProductCategory.Valuetruetrue#528ae7BoldWhite2pt2pt2pt2pt=Fields!SubCategory.Value1in=Fields!SubCategory.Valuetruetrue#c0c0c0BoldWhite2pt2pt2pt2pt1inTotaltruetrue#c0c0c0BoldWhite2pt2pt2pt2ptBefore1inTotaltruetrue#528ae7BoldWhite2pt2pt2pt2pt1inTotaltruetrue#528ae7BoldWhite2pt2pt2pt2ptBeforeDataSet15.92667cm0.42333cm2.54cm15.24cm=Fields!Region.Value=Fields!OrderYear.Value=Sum(Fields!SalesAmount.Value)PrimaryPrimaryBlack1pt30pt0pt