##### Options tab Click the drop-down list to the left of the Add button, and select an option. Click Add. Select or enter information for the option you chose. See table below. Click Accept or Apply.
Field | Notes
--- | ---
Show Max/Min/Avg/Total | Check the appropriate boxes to show the maximum value, minimum value, average, or total at the bottom of the columns. Enter the Column ID of the column that you want labels to be in. |
Show first ___rows | Enter the maximum number of rows to be displayed when the report is previewed or run. This does not include the Max/Min/Avg/Total rows. NOTE You can enter a value or variable name in this field. If you enter a variable, it must be defined on the Variables tab.
Sort column | Sorts the specified column(s) from A to Z or 1 to ... Example of comma separated list of column IDs: date_range, kw_usage, normalizer Check Reverse Sort to sort Z to A, ... to 1.
Filter rows | Select Include row when or Exclude row when a specified column (ID) equals a specified value.
NOTE You can use multiple options for your report, but be aware that they will be processed in the order that they appear in the table at the top of the Options page. For example, if your first option is to Show the first 10 rows and your second option is Filter rows, only the 10 rows will be filtered. To change the order of processing, select an option in the table and then click or .