Hello,
I've just created a summary report on Campaigns & Members grouped by Campaign type (picklist).
For each campaign type (Events, Telemarketing, Customers... ) the sum of Responded members is showed.
Everything works well till this point.
The problems occurs when I need the sum of UNIQUE responded by Campaign type.
Example: Contact James Brown is a member of three different campaigns of Event type. In all Campaigns has a responded status.
In my report above mentioned, in the colums of Event type, he counts 3 responded. I need he's counted as one.
Any suggestion?
2 answers
Have you tried the new Count Unique Values option in lightning reports?
https://help.salesforce.com/articleView?id=reports_count_unique_values.htm&type=5
