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
Campaigns) a unique count on
Campaign Members with
Contact ID where the Field
'Status' = 'Volunteers' - who are both active and inactive
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.