5.2 Manipulating a Data Block
Data Worksheets allow you to perform a full range of data manipulations, including joins, filtering, grouping, and table concatenation. In the next example, you will use some grouping and aggregation tools to manipulate the data block that you created earlier in Constructing a Data Block. Follow the steps below:
1. In the data block's title bar, press the 'Group and Aggregate' button. This opens the 'Aggregate' dialog box.

2. In the 'Aggregate' dialog box, make the following selections:
a. For the 'Order.Date' field, select the 'Group' checkbox and select 'Month' from the right menu.
b. For the 'Product.Total' field, select the 'Aggregate' checkbox and choose 'Sum' from the right menu.

3. Press 'OK' to exit the 'Aggregate' dialog box.

The grouping that you specified is now applied to the 'Date' and 'Total' columns of the table. The 'Category' column is hidden because no grouping options were specified for it.
There are many further manipulations you can make to a data block. See Manipulating Tabular Data in Data Mashup for full details.
See Also
Grouping, in Data Mashup, for full information about grouping and aggregation.
| << 5.1 Constructing a Data Block | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.3 Saving a Data Block >> |