Use a Cross-Tab
  1. Go to Insert > Cross-Tab
  2. Place the Cross-Tab in the Report Header or Footer section
  3. Right-click on the Cross-Tab object and select Cross-Tab Expert
  4. Add the appropriate fields to the Columns, Rows, and Summarized Fields boxes
  5. Go to the Style and Customized Style tabs to add any additional formatting
  6. Click OK