# Configuring Cross Tab

The power user can set the following preferences for the Cross Tab component.

- Data source controls: Select from the available data sources in the drop-down list, and then click Update data source to bind your selection to the component. (If you are changing data sources, you must do so before entering your Analytics statement.)

- Analytics Statement: Enter an Analytics statement to return cross-tab values.

  Note: Using fields with too many values in your GROUP BY clauses may cause your cross tab results table to become too large to be useful.
- Cell Limit: Set a threshold to prevent too large a grid from being rendered on the Cross Tab page. In general, you should not make this value, which represents the number of cells rendered in the cross tab results table, much larger than the default. A table with many thousands of cells is time-consuming to render and difficult for the end user to read.
- Respect data source query state: When this box is checked, the Cross Tab component is dependent on its data source query state, which means the metric values should update when the data source query state changes. When the box is unchecked, it is independent of the data source query state, so the metric values should remain constant regardless of the data source query state.

- Test analytics query: Validate the Analytics statements before loading the metrics into the component. (This step is required.)

  After you test and debug your Analytics query, click Save.

  When you save, the Configuration section is populated with metric, row, and column information.

- Configuration: Adjust the table that your end users will see.

  In the Metrics section, you can configure general metric options or an individual metric. Click the ... button in the top right corner of the panel to launch its formatting options, where you can change the axis on which metrics are displayed or add metric totals.
  Note: Totals are computed using the same aggregating function as the original metric. For example, metrics computed using the average function (AVG) display an overall average for the Total. Because totals may be confusing in cases where the ARB function is used, you may not want to display totals in such cases.

  For any individual metric, click the ... button on its label to access formatting options, where you can change the display name and format the data.

  You can drag metrics to reorder them, and remove a metric from the cross tab result table display by unchecking it.

  Note: To improve performance, if you do not want to display a metric, it is better to remove it from the Analytics statement than it is to uncheck it.

  In the Row Group and Column Group section, you can drag items anywhere in the row and column panels. Each GROUP BY item contains a toggle that can be used to set ascending or descending order.

- View Options: Modify the dimensions (in pixels) of the table and its window.

  Note: The initial generated table will be fit into the size of the component, regardless of how many rows or columns there are. You can use these controls to make the table larger than the component space and navigable with scroll bars.
- Preview table: Preview the cross tab display as it will appear to the end user.