SELECT
    *
FROM
    OPENQUERY(DWDB001AS,
        '
            WITH
                MEMBER [Measures].[ROH Total Sold Gross]                AS [Measures].[ROH Total Sold Dollars] - [Measures].[ROH Total Sold Cost], FORMAT_STRING=''Currency''
            SELECT
                {
                    [Measures].[ROH Total Sold Gross]
                } ON COLUMNS
            FROM
                [ServiceDept]
        ')