title: How to sum the values of an measure in MDX?
body: <p>I am not sure how to put this but, trying to sum the values of an measure using MDX.</p>
  
  <p>My MDX is as follows :</p>
  
  <pre><code>select {[CompanyDimension].[Foo], 
          [CompanyDimension].[Bar],
          [CompanyDimension].[CDK]} on columns,
  
  TopCount([${SLRDimension}].Children, 
           10, 
           [Measures].[ProjectCountMeasure]) on rows
  
  from [Foo_Cube]
  
  where ([FAreaDimension].[Admin])
  </code></pre>
  
  <p>For this expression, I am getting following output :</p>
  
  <pre><code>+----------------------------------------------------------------------+
  |                     | CompanyDimension.NameHierarchy                 |
  +----------------------------------------------------------------------+
  | SLRDimension        | Foo | Bar     | CDK
  +----------------------------------------------------------------------+
  | Development         | 1   | 1       | 6
  | Testing             |     |         | 3
  | Implementation      |     | 1       | 5
  | Reports             | 1   |         | 4
  | Planning            | 1   |         | 5
  | Reporting           |     |         | 1
  | Coding              |     |         | 2
  | Performance         |     |         | 1
  | Designed            |     | 1       |
  | Designing           |     |         | 2
  +----------------------------------------------------------------------+
  </code></pre>
  
  <p>Now I want to get the sum of values per row. for example, in 1st row for <code>Development</code>, I want its corresponding value to be <code>7</code> instead of having 3 values i.e. 1, 1, 6</p>
  
  <p>I am newbie to MDX world so I do not know how to do this. Please help !</p>
  
  <p>I want final values as follows :</p>
  
  <pre><code>+----------------------------------------------------------------------+
  |                     | CompanyDimension.NameHierarchy                 |
  +----------------------------------------------------------------------+
  | SLRDimension        | Sum 
  +----------------------------------------------------------------------+
  | Development         | 7
  | Testing             | 3
  | Implementation      | 6
  | Reports             | 5
  | Planning            | 6
  | Reporting           | 1
  | Coding              | 2
  | Performance         | 1
  | Designed            | 1     
  | Designing           | 2
  +----------------------------------------------------------------------+
  </code></pre>