1. Create a query of gifts given to the campaign. Be sure to create a gift query.
  2. On the Output tab of the query, select:
    Campaign Description
    Fund Description
    Appeal Description
    Gift Amount
  3. Save the query.
  4. Create a pivot report based on the query.
  5. In the Pivot Table Field List, double click on Campaign Description, Fund Description, Appeal Description, then Total Gift Amount.