Crosstabs in Reports
A cross tab is a summary tool for analyzing the data in a report. For example, a crosstab in an evaluation report might look at the score given by each evaluator to each organization/applicant. A crosstab examining awarded grants might sum the amounts awarded by program area and process.
Remember to save your changes after building a crosstab. The crosstab can be exported in an Excel, CSV, or PDF format.
Follow these steps to build a crosstab:
- Within a report you've built in GLM/SLM, click Add Crosstab.
- Choose a header values column (the variable to display at the top of the crosstab), a label values column (the variable to display on the side of the crosstab), and an 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 amount awarded is being aggregated, and we've chosen a sum as the function. This means that the highlighted cell shows the following data: The sum of the amounts awarded for requests with "Health" as the program area, and that are within the 2018 Fall Grants process.