11,677
edits
Changes
Importing a new version from external source
'''See a [[Tables Tutorial|video tutorial]] about tables'''.
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.
In [[Execute a Dashboard|run-time]] cross tables have navigation buttons [[File:table_nav.png|link=]] where you can change pages by clicking the arrows or typing the page number directly in the input box, the option to change the number of rows per page [[File:table_rowspages.png|link=]] and displays information [[File:table_rowspagesinfo.png|link=]] about current and total rows.
For simple table options, see [[Table]].
'''Examples'''
[[File:ctable_ex.png|link=]]
The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings.
[[File:ctable_ex2.png|link=]]
The second example, shows a ''Product by Weekday Gross Sales'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
'''Data Properties'''
* [[Advanced row filter]]
* [[Column order]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Total column]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Alternate row colors]]
* [[Grid line color]]
* [[Object dimensions]]
* [[Sequence column]]
* [[Object positions]]
'''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]]
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.
In [[Execute a Dashboard|run-time]] cross tables have navigation buttons [[File:table_nav.png|link=]] where you can change pages by clicking the arrows or typing the page number directly in the input box, the option to change the number of rows per page [[File:table_rowspages.png|link=]] and displays information [[File:table_rowspagesinfo.png|link=]] about current and total rows.
For simple table options, see [[Table]].
'''Examples'''
[[File:ctable_ex.png|link=]]
The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings.
[[File:ctable_ex2.png|link=]]
The second example, shows a ''Product by Weekday Gross Sales'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
'''Data Properties'''
* [[Advanced row filter]]
* [[Column order]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Total column]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Alternate row colors]]
* [[Grid line color]]
* [[Object dimensions]]
* [[Sequence column]]
* [[Object positions]]
'''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]]
