1. Create a gift query 2. On the Criteria tab, select Gifts, Batch number not blank 3. On the Output tab, select Gift Amount and Batch Number 4. Pull this query in a new Pivot Report. 5. Drag the field "Gift Batch Number" into the row fields section, and drag "Total Gift Amount" into the center totals section.