1,438
edits
Changes
no edit summary
<translate>
<!--T:1-->
[[File:mainmenu5.png]]
'''Watch a [[Tables Tutorial|video tutorial]] about tables'''.
<!--T:2-->
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.
<!--T:3-->
The Cross Table object needs two [[Dates]] or [[Texts]] columns (or one of each) and supports many [[Value]] columns.
<!--T:4-->
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.
<!--T:5-->
In [[Execute a Dashboard|run-time]] cross tables have navigation buttons [[File:Tabela Cruzada 1+en-US.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:Tabela Cruzada 2+en-US.PNG]] and to display information [[File:Tabela Cruzada 3+en-US.PNG]] about current and total rows.
<!--T:6-->
For simple table options, see [[Table]].
<!--T:7-->'''ExampleExamples''' <!--T:8-->[[File:Tabela Cruzada 4+en-US.PNG]]
<!--T:10-->
[[File:Tabela Cruzada 5+en-US.PNG]]
<!--T:11-->
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''.
<!--T:12-->
'''Data Properties'''
<!--T:13-->* [[Advanced row filterObject Filters|Filters]]* [[Conditional Formatting]]* [[Rows sort|Rows Sort]], * [[Column order|Colum Order]], * [[FiltersTotal column|Total Column]], * [[Total row|Total Row limit]], * [[Rows sortAdvanced row filter|Advanced Row Filter]], * [[Total columnRow limit|Row Limit]], * [[Total rowShow Pager]] <!--T:20-->'''Header Properties'''
<!--T:21-->
* [[Header Properties]]
<!--T:14-->
'''Title Bar Properties'''
<!--T:15-->* [[Title bar Properties]]
<!--T:16-->
'''Layout Properties'''
<!--T:17-->* [[Sequence column|Sequence Column]]* [[Alternate row colors|Alternate Row Colors]], * [[Grid line colorHide Border|Show Border]], * [[Object dimensionsBorder color|Border Color]], * [[Sequence columnGrid line color|Grid Line Color]], * [[X positionObject positions|Object Positions]], * [[Y positionObject dimensions|Object Dimensions]]
<!--T:18-->
'''Object Columns Properties'''
<!--T:19-->''Data Properties''* [[Selected column]]* [[Column filtersname]]* [[Data type|Data Type]], * [[Column label|Column Label]], * [[Column nameFunction]], * [[Data typeColumn filters]], * [[Decimal placesConditional Formatting]], * [[Delete column|Remove Column]]* [[Decimal places|Decimal Places]], * [[FunctionThousand sep.|Thousand Sep.]], * [[Mask]], <!--T:22-->''Styles''* [[Thousand sep.Column width|Column Width]], * [[Column font|Column Font]], * [[Column font colorsize|Column Font Size]], * [[Column font sizebackground color|Column Background Color]], * [[Column font stylecolor|Column Font Color]], * [[Column widthfont style|Font Style]], * [[Text alignment|Text Alignment]]</translate>