- Create a gift query filtering on the desired criteria.
- On the Output tab, select the following fields:
Appeals> Appeal Category
- Run the query and save it.
- Go to Reports, Pivot reports and create a new Pivot report.
- Include the gift query created in Steps 1-3. Click Generate.
- From the Pivot Tables Field list, drag the Appeal Category field to the Row section.
- Then drag the Total Gift Amount field to the Totals section.