Pivot Reports use the results of a query to create the report. Including one-to-many fields in Output can cause duplicates to appear in the query results.

Alternative Solutions:

  • Remove the one-to-many fields in query results
  • If summary information is not needed create a gift query to group together the gifts that the pivot report needs to look at