11,677
edits
Changes
Updating to match new version of source page
[[File:mainmenu5.png]]
'''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.
[[File:Tabela Cruzada 4+en-US.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.
[[File:Tabela Cruzada 5+en-US.PNG]]
The second example, shows a ''Product by Weekday Profit'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
'''Object Columns Properties'''
''Data Properties''* [[Selected column]]* [[Column name|Column Name]]
* [[Data type|Data Type]]
* [[Column label|Column Label]]
* [[Function]]
* [[Column filters]]
* [[Conditional Formatting]]
* [[Delete column|Remove Column]]
* [[Decimal places|Decimal Places]]
* [[Thousand sep.|Thousand Sep.]]
* [[Mask]]
''Styles''
