---
schema_version: "1"
id: 038298f411ac46aedaa13750b84a5a2c06c2923feb2ce30f0b304c7b061096e8
title: "Example: Using Row Limits in Report Filters"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_row_limit_example.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_row_limit_example.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 553205ccbbb463771bb12157c6911dbcec564a8d6caefe0f70fdfeb8e1f7ccb5
description: Here is where you can see a sample of a report filter using a field filter, filter logic, and a row limit.
products:
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Group</strong>, <strong>Essentials</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d59102e88">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d59102e88 ">To create, edit, and delete reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d59102e88 ">
              <dl>

                <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

                <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Create and Customize Reports <p>AND</p>
                  <p style="margin-bottom:0;">Report Builder</p>
                </dd>

              </dl>
            </td>

          </tr>
        </tbody>
      </table>

Say you are a sales executive who wants to see which California accounts currently have the most potential to generate revenue:

1. Click **New Report** from the Reports tab.
2. Open the **Accounts & Contacts** report type, choose **Accounts**, and click **Create**.
3. 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
4. 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).
5. 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.

#### See Also

- [Filters Type Reference](https://help.salesforce.com/s/articleView?id=analytics.choosing_filter_options.htm&release=264.0.0&type=5 "Several different types of filters help you scope your report data: standard filters, field filters, cross filters, and row limit filters. Each filter type filters your report in different ways. This list of filter types helps you choose the right filter types for your report.")
- [Limit Report Results](https://help.salesforce.com/s/articleView?id=analytics.reports_limiting.htm&release=264.0.0&type=5 "Set limits to the scope of your report to avoid processing too many records. The built-in choices for limiting your results vary according to the object you’re reporting on.")