Rollup and Report on Who
Summary
This explains a clever way to combine rollup summary fields with formula fields to present Salesforce users with clickable counts on record pages that link directly to filtered reports. It solves the common problem of showing count metrics while making it easy for users to drill into the underlying data without confusion or multiple clicks. Using a hidden helper rollup field with DLRS or standard rollups and a formula field hyperlinking to a report filtered by the current record Id delivers an elegant UX improvement. Salesforce teams can implement this lightweight pattern to enhance reporting visibility and usability on page layouts.
Takeaways
- Use a hidden rollup summary as a data helper for metrics.
- Create a formula field that hyperlinks counts to filtered reports.
- Document rollup fields especially when using DLRS with clear labels.
- Leverage URL filters in report links to show related data dynamically.
- Avoid clutter and usability issues from filtered related lists.
Here's an interesting challenge. Modern Classrooms Project, who runs a program for teachers, wanted to be able to show, on the account page, counts of various program metrics. For each of those metrics, they also wanted to make it easy for users to see which records went into those counts. Taken on their own, either request seems pretty easy. If you want a count (such as enrolled participants from this school) you can make a rollup summary field, either standard or using DLRS . And if you want to see the data that goes into that count, you run a report. [In theory, a related list could also fill this need. But if we're talking about having filters on the count or different counts with different filters, having filtered related lists for each scenario will get out of hand. Even for only one count, a filtered related list isn't going to be very functional and probably isn't a good use of screen real estate.