title: SSAS: Percent of Total not working in hierarchy
body: <p>I have a simple olap cube - one set of measures and some unexciting dimensions.</p>
  
  <p>I've add one calculation to get the "percent of total" sales against the gross sales measure. The code for this calculation is:</p>
  
  <pre><code> ([Dim Stores].[Store Name].CurrentMember, [Measures].[Gross Sales]) 
   / 
   ([Dim Stores].[Store Name].Parent, [Measures].[Gross Sales])
  </code></pre>
  
  <p>This works.</p>
  
  <p>Within the store dimension, there is a hierarchy called 'By State' where the stores are contained within. </p>
  
  <p>Two questions please:
  1. Any idea why the calculation would not work when I use the the 'By state' hierarchy i.e. the same calculation grouped by the next level up?</p>
  
  <ol>
  <li>The state problem aside, any idea why my grand total shows an error even when I just use the Store Name?</li>
  </ol>
  
  <p>TIA!</p>