Part of the org app has yet to transition to Lightning, so this question relates to Classic and Reports. I need to get a Unique Count of PICKLIST FIELD linked to a Parent Object I can't use UNIQUE COUNT ID as it's CLASSIC. I'm hoping someone can assist, Thanks!
Need to create a report in salesforce on Campaign Members
(which is a related list to Contacts
& Campaigns
) a unique count on
Campaign Members
with Contact ID
where the Field 'Status' = 'Volunteers'
- who are both active and inactive
Per quarter
Currently, the Classic report with a cross filter shows the same volunteers multiple times.
I tried doing creating a Formula Field on Campaign Member IF(ISPICKVAL(Status, "Volunteer"), 1, 0)
but this did not work. Neither did the Power on One as it has is field value of Object.
What is the best solution here? Would a Joined Report work and what would this look like? Thanks in advance.