About Discoverer worksheet types

In Discoverer you can display data in two different ways:

• in a table worksheet - see "About table worksheets"

• in a crosstab (i.e. cross-tabular) worksheet - see "About crosstab worksheets"

About table worksheets

A table worksheet lists data in rows and columns. The figure below shows an example table worksheet analyzing profit values for cities within a region.

Figure 1-2 A table worksheet

Description of the illustration ty_tab.gif

Note: The table worksheet style is only used for analyzing relational data.

About crosstab worksheets

A crosstab worksheet (short for cross-tabulated worksheet) relates two different sets of data and summarizes their interrelationship in terms of a third set of data. The figure below shows an example crosstab analyzing profit values for regions by department.

Figure 1-3 A crosstab worksheet

Description of the illustration ty_ct.gif

Key to figure:
a. Top axis, containing the Region item.
b. Left axis, containing the Department item.
c. Data points, containing profit sum figures for each region in each department.

The region and department items are displayed as rows and columns on the crosstab. Each row and column intersection shows a data point, which in this case is the profit total for a particular region and a particular department.