title: MDX query adding SUM column
body: <p>I have written the following MDX  </p>
  
  <pre><code>WITH MEMBER [Measures].[SumReturns] AS
    ([Dimension1].[GCode].defaultmember,[Measures].[GScore Sum])  
  
  SELECT
     non empty  
     (  
  
        {[Dimension1].[Description].children},  
        {[Dimension1].[GCode].children},  
        {
           [Measures].[GScore Sum],  
           [Measures].[SumReturns]  
        }
  
     )  
     on columns,  
     non empty
     (
        [Dimension2].[DCode].[DCode] *  
        [Dimension2].[DName].[DName] *   
        [Dimension2.[Barcode].[Barcode] *  
        [Dimension2].[LN].[LName] *  
        [Dimension2].[FN].[FName]   
  
     )
     on rows
  FROM [MCube]
  WHERE 
  (
     {[Dimension2].[HARC].[DCode].&amp;[0000]}
  )  
  </code></pre>
  
  <p>The query is giving me the results below:  </p>
  
  <p><img src="https://i.stack.imgur.com/yte59.jpg" alt="Actual Results"></p>
  
  <p>But what I expected instead was these results:</p>
  
  <p><img src="https://i.stack.imgur.com/hDk7q.jpg" alt="Expected Results">  </p>
  
  <p>Any suggestions on how to get the desired results?</p>