Crosstabs Overview

To view the Crosstabs report, click Menu, and under Data Management, click Crosstabs.

Use Crosstabs to build reports by drawing on all the data in TME ClearView.
The data shown in the graphics in this user guide is test data, and not reflective of TME data.

This topic includes information on the following:

Identifying Sections on the Crosstabs Report Page

The sections of the Crosstabs report page are numbered in the following graphic. The numbers in the graphic are referred to throughout Crosstabs Help topics for clarification and are shown as a number in parenthesis, for example, the Column Area (4).

The Crosstabs report page includes three main sections:

The left column, which includes numbered items 2-6.
The middle column, which includes numbered items 9-11.
The right column which includes one numbered item 12.

Cross Tabs report graphic

Working with Hidden Fields

The Hidden Fields list (2) shows a list of items that can be dragged into the report. The Hidden Fields list includes two types of items:

Measures, which include numeric or calculated data, for example, alert counts, survey counts, and scores.
Dimensions, an aggregate term, which includes all the other items in the Hidden Fields list that are not Measures, as described in the following examples:
- Example 1: Create a report in which Scores, a Measure, are broken down by Month, a Dimension.
- Example 2: Create a report in which Alert Counts, a Measure, are broken down by Models, a Dimension.

Working with Measures

To view data, you must include a Measure in a report. You can drag Measures into either of the following:

Data Area (6)
Drop Data Items Here (10)

If you drag a Measure into Data Area (6), it's immediately visible in Drop Data Items Here (10).

A Measure cannot be dragged into Row Area (5) or Column Area (4).

Working with Dimensions

After you have dragged measure into the report, you can drag Dimensions into the report as filters, columns, or rows.

The table below shows the locations to which you can drag a Dimension. The Dimension is then shown in both the area or the drop fields here location.

Drag Filters here	Drag Columns here	Drag Rows here
Filter Area (3)	Column Area (4)	Row Area (5)
Drop Filter Fields Here (9)	Drop Column Fields Here (12)	Drop Row Fields Here (11)

Removing Measures and Dimensions from a Report

To remove Measures and Dimensions while creating a report, do either of the following:

To remove specific Measures and Dimensions from the report, drag them one by one into any location within Hidden Fields (2).
To remove all Measures and Dimensions from the report, click .