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 Antworten
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