Crosstabs

A crosstab (cross-tabulation) is a table that shows the number of occurrences of each of the specified category combinations in your data sample. Crosstabs have different data, layout, and format options than tables or charts.

Available fields are divided into Fields and Measures. Measures are fields that contain data values. Fields can be added to crosstabs as row groups or column groups. Measures can be added to crosstab rows or columns. You can add one or more measures as columns, or add one or more measures as rows. You cannot have one measure as a column and another as a row in the same crosstab. All available fields for tables are listed in the Data Source Selection pane in the Ad Hoc Editor.