A crosstab is a summary tool for analyzing the data in a report. For example, a crosstab examining awarded grants might sum the amounts awarded by program area and process.
- Click Reporting on the upper navigation bar, and then click Reports & Data Sets.
- Click Run Report next to the report to which a crosstab will be added.
Click Add Crosstab.
- Select a Header Values Column, a Label Values Column, and an Aggregate Values Column.
- Header Values Column - The variable to be displayed at the top of the crosstab.
- Label Values Column - The variable to be displayed on the side of the crosstab.
- Aggregate Values Column - The variable that will be aggregated within the crosstab.
- Select an Aggregate Function.
This is the mathematical function to be performed on the aggregate values column based on the header and label values columns.
In this example, the sum of the amounts awarded for requests with Arts as the focus area and that are within the Fall Grant Cycle process is $228,000.
- Click Save New Report after building the crosstab.
- The crosstab can be exported in an Excel, .csv, or .pdf format.
- The crosstab can be exported in an Excel, .csv, or .pdf format.