11,677
edits
Changes
Updating to match new version of source page
[[File:mainmenu5.png]]'''See Watch a [[Tables Tutorial|video tutorial]] about tables'''.
A table is like an 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 [[DateDates]] or [[TextTexts]] 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_navTabela Cruzada 1+en-US.png|link=PNG]] 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_rowspagesTabela Cruzada 2+en-US.png|link=PNG]] and displays to display information [[File:table_rowspagesinfoTabela Cruzada 3+en-US.png|link=PNG]] about current and total rows.
'''Examples'''
[[File:ctable_exTabela Cruzada 4+en-US.png|link=PNG]]
The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount amount of ''Cost'' and ''Profit'' for these crossings.
* [[Object Filters|Filters]]
* [[Conditional Formatting]]
* [[Rows sort|Rows Sort]]
* [[Column order|Colum Order]]
* [[Total column|Total Column]]
* [[Total row|Total Row]]
* [[Advanced row filter|Advanced Row Filter]]
'''Layout Properties'''
* [[Sequence column|Sequence Column]]* [[Alternate row colors|Alternate Row Colors]]* [[Hide Border|Show Border color]]* [[Grid line Border color|Border Color]]* [[Object dimensionsGrid line color|Grid Line Color]]* [[Sequence columnObject positions|Object Positions]]* [[Object positionsdimensions|Object Dimensions]]
'''Object Columns Properties'''
* [[Column name]]
* [[Data type|Data Type]]* [[Decimal places]]* [[Delete columnColumn label|Column Label]]
* [[Function]]
* [[Column filters]]
* [[Conditional Formatting]]
* [[Delete column|Remove Column]]
* [[Decimal places|Decimal Places]]
* [[Thousand sep.|Thousand Sep.]]
* [[Mask]]
''Styles''