About Discoverer worksheet types |
 Previous |
 Next |
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.
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.
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.