title: How to sum up the records on an Object with respect to a Month
body: <p>Hello there Salesforce experts,</p>
  
  <p>I have an Object <strong>Monthly_cc__c</strong> where there are records flowing in for each country every month.
  Below are the fields</p>
  
  <ol>
  <li>ID is the record ID  </li>
  <li>Processing Date</li>
  <li>Processing Year</li>
  <li>Processing Month</li>
  <li>Distributor__c is the Master-Detal relation ship with Account.</li>
  <li>Operating Company (IND, AUS, GBR...)</li>
  </ol>
  
  <p>Now for every record there are the below fields </p>
  
  <ol>
  <li>Personal CC</li>
  <li>Monthly CC</li>
  </ol>
  
  <p>For each Operating company these results are being sent and for the same Processing date we have various records for different Operating companies.</p>
  
  <p>I would like to sum up the Personal cc for January for us to not complicate our SQL query. </p>
  
  <p>Please let us know a solution on how to accomplish this task.</p>
  
  <p>Thank you.</p>
  
  <p>The expected result would be</p>
  
  <p>For January, 2017</p>
  
  <ol>
  <li>Personal CC = sum(AUS,IND,GBR'S Personal CC)</li>
  <li>Monthly CC = Sum(AUS,IND,GBR'S Monthly CC)</li>
  </ol>