Most Salesforce admins know how to create a Summary report and pin a chart to a dashboard. These 10 features go further — and most of them are underused on every org I've audited.
1. Cross Filters — "With" and "Without"
Cross filters let you filter a report based on whether a related object exists or doesn't. Example: "Accounts without Opportunities in the last 90 days" — great for finding neglected accounts. Add a Cross Filter from the Filters panel.
2. Bucket Fields
Group values into custom categories without changing the underlying data. Bucket a numeric Annual Revenue into "Small", "Mid", "Enterprise" directly in the report. No formula field needed.
3. Report Charts on Record Pages
Add a report chart component to any Lightning record page via the App Builder. Sales managers can see their team's pipeline chart on the Opportunity object page without leaving the record.
4. Dynamic Dashboards
A single dashboard that shows each user their own data, not the admin's data. Set the dashboard to "Run as logged-in user" instead of a fixed user. Essential for self-service sales dashboards.
5. Conditional Highlighting
In Summary and Matrix reports, set colour thresholds on numeric columns. Green above target, amber within 10%, red below. Managers scan the table in seconds instead of reading every row.
6. Row-Level Formulas
Create a formula column that computes per-row. Example: Days since last activity = TODAY() - Last_Activity_Date__c. Different from Summary formulas — these calculate at each row, not aggregated.
7. Joined Reports
Combine up to five different report blocks — each with different objects, filters, and columns — in one view. Classic use: compare this quarter's pipeline vs. last quarter's in a single report.
8. Report Subscriptions
Schedule a report to email you (or a distribution list) on a set schedule with conditions. "Email me when total pipeline drops below £500k." No Flow needed — it's built into every report.
9. Drill Down in Dashboards
Set each dashboard component's "Drill Down" destination to a specific report or related list. Users click a chart bar and land on the filtered report, not the generic report list.
10. Dashboard Filters
Add up to three filter fields to a dashboard that viewers can change without editing the dashboard. A single "Pipeline by Region" dashboard can filter to any region without cloning the dashboard for each team.