> ### Task 4: Set up data for the cross tab

> In this procedure, you set up the following items:

> | A data group, or dimension, containing values to use as the cross tab’s row headings

> | A data group, or dimension, containing values to use as the cross tab’s column headings

> | A summary field, or measure, providing aggregate values to use in the cells of the cross tab

> Data that you set up for a cross tab is stored in an entity called a cube.

> 1 | In Data Explorer, right-click Data Cubes, and choose New Data Cube.

> 2 | In Data Cube Builder, specify the following information:

> | In Name, type

> Sales Cube

> | In Primary dataset, select Sales.

> 3 | Choose Groups and Summaries.

> 4 | In Available Fields, expand Sales. Drag STATE and drop it on the following location, as shown in Figure 16-4:

> (Drop a field here to create a group)

> Figure 16-4 Adding a state group to the cube

> 5 | In Add Group, use the default group name. Choose OK.

> 6 | Drag PRODUCTLINE from Available Fields and drop it on the following location:

> (Drop a field here to create a group)

> 7 | Use the default group name.

> Cross Tab Cube Builder shows the STATE and PRODUCTLINE dimensions you created, as shown in Figure 16-5.

> Figure 16-5 Cross Tab Cube Builder displaying two groups

> 8 | Drag EXTENDED_PRICE from Available Fields and drop it on the following location:

> (Drop a field here to create a summary field)
> EXTENDED_PRICE(SUM) appears under Summary Field. SUM indicates that the SUM aggregate function is used to calculate the totals of the EXTENDED_PRICE values. The cube builder selects the SUM function by default. You can, however, select a different function to apply to a measure by selecting the measure, then choosing Edit.
> Figure 16-6 shows the dimensions and measure you defined.

> Figure 16-6 Cross Tab Cube Builder displaying two groups and a summary field

> 9 | Choose OK to save the cube. The Sales cube appears under Data Cubes in Data Explorer.

> 10 | Expand the Sales Cube to view its contents, as shown in Figure 16-7.

> Figure 16-7 Data Explorer showing the Sales cube

(c) Copyright Actuate Corporation 2013