title: Average of sums in MDX query
body: <p>How can I compute average of sums in MDX? I want to compute sum of spending for each person and then compute an average of it. I have the following query so far, but I believe it gives me wrong result:</p>
  
  <pre><code>WITH MEMBER [Measures].[Average] AS
  AVG(Measures.cost)
  SELECT [Measures].[Average] ON COLUMNS
  FROM
  ( SELECT Measures.cost ON COLUMNS,
  {Person.[Last name].MEMBERS}*
  {Person.[First name].MEMBERS} ON ROWS
  FROM Cube )
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>