Difference between revisions of "Cross Table"
| Line 8: | Line 8: | ||
For simple table options, see [[Table]]. | For simple table options, see [[Table]]. | ||
| + | |||
| + | |||
| + | '''Example''' | ||
[[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 ''Profiut'' for these crossings. | ||
Revision as of 18:03, 23 April 2013
Implements a table like object, a collection of columns and rows, that displays data as a crossed view of two columns.
The Cross Table object needs two Date or Text columns (or one of each) and supports an unlimited number of 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 Profiut for these crossings.
Data Properties
Advanced row filter, Column order, Filters, Row limit, Rows sort, Total column, Total row
Title Bar Properties
Layout Properties
Alternate row colors, Grid line color, Object dimensions, Sequence column, X position, Y position
Object Columns Properties
Column filters, Column label, Column name, Data type, Decimal places, Delete column, Function, Mask, Thousand sep., Column font, Column font color, Column font size, Column font style, Column width, Text alignment
