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.

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:	Enhanced Folder Sharing Create and Customize Reports AND Report Builder

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:
1. Billing State/Province equals CA
2. Annual Revenue greater than 10000000
3. 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.

Product Area