Remove any one-to-many fields from the query output.  Examples of one-to-many fields are constituency code, campaigns, funds, and appeals.



If you must include one-to-many fields in the query output so those fields appear on the pivot report, refer to Why are there duplicates in the query results and how to remove them (BB61118) for ways to reduce the duplicates. Note: Due to the way the SQL query language works, you may not be able to remove all duplicates.