Difference between revisions of "Cross Table"
| Line 1: | Line 1: | ||
| − | + | A table like object, a collection of columns and rows, that displays data as a crossed view of two text or date columns. | |
| − | The Cross Table object needs two [[Date]] or [[Text]] columns (or one of each) and supports | + | The Cross Table object needs two [[Date]] or [[Text]] columns (or one of each) and supports many [[Value]] columns. |
The data displayed in the Cross Table will be a cross of the Data and Text columns with the first column being the row and the second the column. The Value columns will be shown summarized in the center. | The data displayed in the Cross Table will be a cross of the Data and Text columns with the first column being the row and the second the column. The Value columns will be shown summarized in the center. | ||
| Line 14: | Line 14: | ||
[[File:ctable_ex.png]] | [[File:ctable_ex.png]] | ||
| − | The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and '' | + | The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings. |
Revision as of 17:59, 9 May 2013
A table like object, a collection of columns and rows, that displays data as a crossed view of two text or date columns.
The Cross Table object needs two Date or Text columns (or one of each) and supports many Value columns.
The data displayed in the Cross Table will be a cross of the Data and Text columns with the first column being the row and the second the column. The Value columns will be shown summarized in the center.
For simple table options, see Table.
Example
The above example, shows a cross table of Group (row) by Year (column) and the summarized ammount of Cost and Profit for these crossings.
Data Properties
Title Bar Properties
Layout Properties
Object Columns Properties
