MyEclipse Chart Tools Birt Tips (ii) Use of--cross tab

The most convenient operation of the Birt plugin is to support the generation of crosstab cross table

Here's a simple example of how to set up a cross-table

The data sheet is a sales record table with the following fields: Merchant Shop, categories category, sales Amount

Show the effect for the left vertical row for the merchant, the top horizontal for the product category, the middle of sales, the right for the corresponding merchant's total and bottom of the corresponding product category totals, the lower right corner is a total

------------------------------------------

| Category 1 | Category 2 | Category 3 | Total

------------------------------------------

Merchant 1 |    1 |    2 | 3 | 6

------------------------------------------

Merchant 2 |    1 |    2 | 3 | 6

------------------------------------------

Merchant 3|    1 |    2 | 3 | 6

------------------------------------------

Total |    3 |    6 | 9 | 18

------------------------------------------

Implementation steps:

1, new Data Source.

2, new Data sets.

3, New Data Cubes.

Groups and summaries

Drag available fields in the Shop and category drop a field in groups and summaries to create a group of two group;

Drag drop a from amount to groups and summaries in available fields, where you create a summary field;

OK;

In Data Explorer, modify the name of Goup and Summaryfield and modify the name of the display cubes in Chinese.

4. Drag cross tab to design from palette, drag and drop the group shop in Data Explorer to the left column, drag and drop the group category to the top, and summary fields Amount into the middle;

In design, click the down arrow of Group shop and group category to select Totals to increase row and column totals.

5, Outline Select Crosstab-general-for empty cells,show 0, if there is no value when the default display 0.

6, Preview.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MyEclipse Chart Tools Birt Tips (ii) Use of--cross tab