SELECT
[t1].[Region] AS [Region]
,[t1].[Segment] AS [Segment]
,SUM([t2].[__measure__1]) AS [__measure__2]
FROM (
SELECT
[Orders].[Category] AS [Category]
,[Orders].[Region] AS [Region]
,[Orders].[Segment] AS [Segment]
FROM [dbo].[Orders] [Orders]
WHERE ([Orders].[Category] NOT IN ('Furniture'))
GROUP BY [Orders].[Category], [Orders].[Region],[Orders].[Segment]
) [t1]
INNER JOIN (
SELECT
[Orders].[Category] AS [Category]
,[Orders].[Segment] AS [Segment]
,SUM([Orders].[Sales]) AS [__measure__1]
FROM [dbo].[Orders] [Orders]
GROUP BY [Orders].[Category],[Orders].[Segment]
) [t2] ON ((([t1].[Category] = [t2].[Category]) OR (([t1].[Category] IS NULL) AND ([t2].[Category] IS NULL)))
AND (([t1].[Segment] = [t2].[Segment]) OR (([t1].[Segment] IS NULL) AND ([t2].[Segment] IS NULL))))
GROUP BY [t1].[Region], [t1].[Segment] |