# CrossTabs Tutorial - Create, Format, and Style a CrossTab

> CrossTab Tutorial

## CrossTab Tutorial

### Overview & Examples

A "CrossTab" in Jaspersoft Studio is similar to a Pivot Table in Excel. You need at least three data points to create a CrossTab. One determines the columns in your table; the second determines the rows; the third determines the "measure" (i.e. the data in the table's cells).

#### Example 1:

![](https://950445536-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4GLkzIBhRPJYBUJD8p%2F-M4GLmpngX5uSfgbRicS%2F-M4GM0AJ8WvwA97jSsvy%2Fcrosstab_example_1Resize.jpg?generation=1586207944036438\&alt=media)

This CrossTab contains:

* 1 column for each grade
* 1 row for each site
* 1 cell for every combination of site & grade level, indicating the count of students for each grade level at each site.
* Total column indicating the total count of students for each site, across all grade levels
* Total column indicating the total count of students for each grade level, across all sites.

#### Example 2:

![](https://950445536-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4GLkzIBhRPJYBUJD8p%2F-M4GLmpngX5uSfgbRicS%2F-M4GM0ALoAX94tjXQlAv%2Fcrosstab_example_2Resize.jpg?generation=1586207942975610\&alt=media)

This CrossTab contains:

* 1 column for Assessment Performance Level
* 1 row for each site
* 1 cell for every combination of site & performance level, indicating the count of students at each performance level per site.
* Total column indicating the total count of students for each site, across all performance levels.
* Total column indicating the total count of students for each performance level, across sites.

Go to [**Step 1: Create Your CrossTab**](https://colah.gitbook.io/illuminate-bi-tool-guide/tutorials/crosstabs-tutorial-create-format-and-style-a-crosstab/step-1-create-your-crosstab)

 **Did you know Illuminate can build your BI Tool for you?**\
[Click here to learn about Illuminate's **Report Building Service**.](https://www.illuminateed.com/resources/report-building-service/)