1. Create a new constituent query with no criteria
2. On the Output tab, select the following fields:

Constituent Information->Name
Gifts->Gift Amount
Gifts ->Fund->Fund ID

3. Save the query
4. Create a new Pivot Report
5. Include the query created in the above steps
6. Select to Refresh Pivot data on each run
7. Click Generate
8. Click the field lists and drag and drop the below fields to the below areas:

Name to Drop row fields here
Fund ID to Drop Column fields here
Total Gift Amount to Drop total fields here