title: MDX grouped dimensions
body: <p>I have a dimension  <code>[product].[type]</code> having its member containing <code>'Food','Book','Metal','Meat', etc.</code> My task is to show a categorized dimension to group my sales value, such as, group <code>Food &amp; Meat</code> as <code>0</code>, <code>Metal &amp; Tool</code> as <code>1</code>, <code>Book</code> as 2, etc..</p>
  
  <p>My Query seems doesn't work:</p>
  
  <pre><code>WITH calculated member [Measures].[Grouped Type] AS
    IIF([product].[type].CurrentMember IS [product].[type].[Meat], 0,
    IIF([product].[type].CurrentMember IS [product].[type].[Food], 0,
    IIF([product].[type].CurrentMember IS [product].[type].[Tool], 1,
    ...... , 9)))))
  SELECT {[Measures].[Sales Amount], [Measures].[Grouped Type].Children} on 0
  FROM Cube
  WHERE ([Condition])
  </code></pre>
  
  <p>It looks my total sales amount is shown, but not correctly categorized. any help? Appreciated.</p>