﻿          WITH
          SET [sorted set] AS
          Hierarchize
          (
          (DISTINCT
          {
          AddCalculatedMembers
          (
          {
          [Geography].[Geography].[Country].&[United States],
          [Geography].[Geography].[Country].&[United States].Children
          }
          )
          })
          )
          SELECT
          NON EMPTY
          {
          	[Measures].[Reseller Gross Profit]
			,[Measures].[Reseller Sales Amount]
          } DIMENSION PROPERTIES  PARENT_UNIQUE_NAME,PARENT_LEVEL,MEMBER_TYPE,MEMBER_VALUE
          ON 0
          ,NON EMPTY
          {[sorted set]} DIMENSION PROPERTIES  PARENT_UNIQUE_NAME,PARENT_LEVEL,MEMBER_TYPE,MEMBER_VALUE
          ON 1
          FROM [Adventure Works]
          CELL PROPERTIES
          CELL_ORDINAL
          ,VALUE
          ,FORMATTED_VALUE
          ,FORMAT_STRING
          ,FORE_COLOR
          ,BACK_COLOR
          ,FONT_SIZE
          ,ACTION_TYPE
          ,FONT_NAME
          ,FONT_FLAGS
          ,UPDATEABLE;