In Salesforce, a Multi-Person Calendar Event report displays each event invitee as a separate row in the report, with that invitee listed as the Assigned person. This means that a single event with multiple attendees appears multiple times in the report — once for each attendee. As a result, the report can appear to show duplicate activity records when it is actually showing one row per invitee.
This article explains how to filter a Multi-Person Event report to show only the primary assigned user (the person who originally created or owns the activity), rather than all invitees.
To filter the report so it shows only the person initially assigned to the event — the primary activity owner — and not the invited attendees, add the following filter to your Activity or Event report:
Event Invitation = False
When the Event Invitation field is set to False, the row represents the primary activity owner. When it is set to True, the row represents an invitee.
This filter is available in Activity-based report types in Salesforce and can be applied in the Filters panel of the Report Builder.
To report on all invitees for a given event, do not apply the Event Invitation filter, or filter by Event Invitation = True to see only the invited attendees.
000385053

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.