Skip to main content
Hi Team

 

Quick question, regarding the power of one.  Using it for one of my customers successfully across lots of different reports.  however, they have set me a new challenge and I am struggling.

 

They are a holiday company so have a custom object for properties and every opportunity is linked to a property and a person account.  They want a report for any customers, who have repeat bookings at the same property.

 

So I have created a report, grouped by property and then by Person Account and added a summary using the power of one on #.opportunities.

 

I know I cannot filter on a summary field, record count or custom formula, but is there any other way that anyone knows of for me to filter this so I only see results for the Person accounts that have multiple opportunities at the same property? 

 

They are on Professional edition.

 

Thanks in advance.
3 réponses
  1. 21 oct. 2019, 14:18
    For that you'd need either a Roll-Up Summary field, or a number field that is updated using something like Declarative Roll-Up by Andy Fawcett (it's free) or an App like Roll-Up Helper, or a custom Process, or custom Code like batch Apex