Working with Filters in Crosstabs

To view the Crosstabs report, click Menu, and under Trend It, click Crosstabs.

Review Creating Basic Reports in Crosstabs.

To filter information, you select a dimension that's already in a Row or Column. Then select options from a dropdown list For example, select specific months.

You can also apply a filter by using the Filter Area, shown as item (6) in Crosstabs Overview

To create a report using the Filter Area, review the following report example.

From Hidden Fields, click the plus sign next to Measures, click the plus sign next to Survey, then drag Survey count into Data Area.
From Hidden Fields, click the plus sign next to Organization, then drag Organization into Row Area.
Organization can only be dragged onto Row Area. It includes too much data to be shown as columns.
Levels 2-9 Are shown
At Level 02, click the blue funnel icon, and then select TME.
Click the at TME.
The Survey data is shown.
From Hidden Fields, click the plus sign next to Program, then drag Program to Filter Area.
From Filter Area, click the blue funnel icon at Program.
A dropdown list opens.
Select the program data that you want to view. For example, select Purchase.
Purchase is now shown n the report as a row or column, but the data changed from the data shown in the Step 4 graphic to show only surveys from the Purchase program.
To save the report, enter a report name and click the Save icon.
To download the report, do either of the following:
- To download the report as a PDF file, click .
- To download the report as an Excel file, click .