title: How to get the last, non empty 10 members with MDX?
body: <p>I have an MDX query:</p>
  
  <pre><code>SELECT
  NON EMPTY {Hierarchize({[Measures].[Rating]})} ON COLUMNS,
  NON EMPTY {Hierarchize({[Response].[Response Name].Members})} ON ROWS
  FROM [Ratings]
  </code></pre>
  
  <p>That returns a table of Response Names to Response count. This query returns a row for ALL responses, though, and I just want the most recent 10 responses.</p>
  
  <p>I tried to do this using HEAD like so:</p>
  
  <pre><code>SELECT
  NON EMPTY {Hierarchize({[Measures].[Rating]})} ON COLUMNS,
  HEAD(NON EMPTY {Hierarchize({[Response].[Response Name].Members})}, 10) ON ROWS
  FROM [Ratings]
  </code></pre>
  
  <p>but it gives an error "Syntax error at line 3, column 18, token 'NON'"</p>
  
  <p>If I remove the NON EMPTY, then it works as I would expect (returns only 10 members), but then it includes the empty Ratings. </p>
  
  <p>How can I use NON EMPTY and HEAD together? (Or accomplish the same thing another way)</p>