You are here:
Example: Using Row Limits in Report Filters
Here is where you can see a sample of a report filter using a field filter, filter logic, and a row limit.
Required Editions
| Available in: Salesforce Classic |
| Available in: Group, Essentials, Professional, Enterprise, Performance, Unlimited, and Developer Editions |
| Available in: Enhanced Folder Sharing |
| User Permissions Needed | |
|---|---|
| To create, edit, and delete reports: |
|
Say you are a sales executive who wants to see which California accounts currently have the most potential to generate revenue:
- Click New Report from the Reports tab.
- Open the Accounts & Contacts report type, choose Accounts, and click Create.
-
To find California accounts that either have over $10 million
in revenue or are public companies, click Add | Field Filter and
create these filters:
- Billing State/Province equals CA
- Annual Revenue greater than 10000000
- Ownership equals Public
- To ensure that your results include all California accounts with $10 million in revenue OR that are public, click Add | Filter Logic and enter 1 AND (2 OR 3).
- To limit the number of results for a tabular report to 10, click Add | Row Limit and enter 10. Choose your sort field and sort order. Click OK.
When you click Run Report, your results will contain ten rows and include public companies in California with revenues of more than $10 million.
Did this article solve your issue?
Let us know so we can improve!
