title: MDX Sum values from current month
body: <p>I have the problem with <code>SUM</code> query.
  I want to sum the 'zaplata' from every month, but always I get the sum of all years...</p>
  
  <p>MDX query:</p>
  
  <pre><code>with member [Zapl] as 
     'Sum(
        [Data Zameldowania].[Sprzątanie w dany typ dnia], 
        [Measures].[Zaplata - Sprzatanie]
      )'
  select
     non empty 
        {[Data Zameldowania].[Sprzątanie w dany typ dnia].[Miesiac Slownie]} on 0,
     non empty 
        {[Measures].[Liczba gosci],[Zapl]} on 1
  from [Hurtownia Danych]
  where 
      [Data Zameldowania].[Data sprzątania].[Rok].&amp;[2012];
  </code></pre>
  
  <p>This is what I get from my MDX Query: 
  <img src="https://i.stack.imgur.com/D1qQG.png" alt="enter image description here"></p>
  
  <p>This is what I have in Data Warehouse (SQL qyery from DW shows that in MDX query i get sum of all 'zaplata'. I want to sum 'zaplata' of each mont):</p>
  
  <p><img src="https://i.stack.imgur.com/8Kj3N.png" alt="enter image description here"></p>