Version 2021

Removing report limits

You can set limits on any metric you wish to apply to a report. Limit criteria for this purpose include value (for example, include only items greater than a specified value for the metric applied), rank (for example, include only the top ten items on a list), or percent (for example, include only those items whose value is in the top ten percent of the metric applied).

By removing a report limit, you are removing the limit from the metric that is applied to the report. For example, instead of just showing the top ten items on a list, by removing the limit, you would show all items on the list.

Prerequisite

The Report Data Options dialog box is only available when there is at least one metric on the report. Ensure you have at least one metric on your report before completing step 2.

To remove report limits

  1. Open the report.

  2. From the Data menu, choose ReportDataOptions. The Report Data Options dialog box opens.

  3. Under Categories, expand Calculations, and then select Report Limit. Calculations - Report Limit appears on the right-hand side.

  4. Select Clear Report Limit. All listed limits are cleared.

  5. Click OK.

Related Topics