Step 1 - Create Your CrossTab
PreviousCrossTabs Tutorial - Create, Format, and Style a CrossTabNextStep 2 - Size and Position Your CrossTab
Last updated
Was this helpful?
Last updated
Was this helpful?
CrossTab Tutorial
Note: CrossTabs can only be placed in the Footer of your Groups (or in the Summary Band)
Navigate to the Palette Tab
Drag & Drop CrossTab Element onto your summary band, or one of your Group Footers.
When you drop the CrossTab onto your report, a “CrossTab Wizard” will appear.
Click Next to move past the first screen of the CrossTab wizard.
Select the field/variable to use as your Columns
The CrossTab will generate one column for every unique value in the selected field/variable.
For example, if you select the “Grade Level” field, you will get one column for each grade level. Or, if you select the “Site Name” field, you will get one column for each Site in the data.
Click the > button to move the field/variable into the next column.
Click Next
Select the field/variable to use as your Rows
The CrossTab will generate one row for every unique value in the selected field/variable.
For example, if you select the “Grade Level” field, you will get one row for each grade level. Or, if you select the “Site Name” field, you will get one row for each Site in the data.
Click the > button to move the field/variable into the next column.
Click Next
Select the field/variable you want to use as your “Measure”
Click the > button to move the field/variable into the next column.
Select a calculation from the calculation drop down menu.
The available options under calculations will vary depending on whether you have selected a numeric or text field for your measure.
Click Next
The last screen allows you to select from different color schemes. Select the color scheme you want, and click Finish.
