Ask Search:
Tracy BinghamTracy Bingham 

Is it possible to increase the power, of the power of one!

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.
Best Answer chosen by Tracy Bingham
Steve MolisSteve Molis
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

All Answers

Steve MolisSteve Molis
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
This was selected as the best answer
Tracy BinghamTracy Bingham
I had a feeling that would be your answer, we are already using roll-up summaries to show multiple bookings per person account but adding an extra level of detail to this to then roll up by the property too, just makes it really messy. (There are well over 300 properties)
Tracy BinghamTracy Bingham
BTW. I had created an idea for this to be standard functionality that was then merged with this idea, so if anyone else would like to see this in a future release, please do vote https://success.salesforce.com/ideaView?id=08730000000Brh8AAC