title: MDX Sum Function
body: <p>We have this data...</p>
  
  <p>Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PhonesSold <br />
  1/1/2011 - 1 <br />
  1/2/2011 - 3 <br />
  1/3/2011 - 2 <br />
  1/4/2011 - 4 <br /></p>
  
  <p>Is it possible to create an MDX query that results in the following results?</p>
  
  <p>Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TotalPhonesSold <br />
  1/1/2011 - 1 <br />
  1/2/2011 - 4 <br />
  1/3/2011 - 6 <br />
  1/4/2011 - 10 <br /></p>
  
  <p>I'm guessing I'll use the SUM function. It has this syntax.</p>
  
  <p>Sum( Set_Expression [ , Numeric_Expression ] )</p>
  
  <p>Now, how do I specify the set? </p>