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.
- This is the mathematical function to be performed on the aggregate values column based on the header and label values columns.
- Click Save New Report after building the crosstab.
- The crosstab can be exported in an Excel, .csv, or .pdf format.