View source for Cross Table/en

<languages/>


[[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 [[Dates]] or [[Texts]] 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: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.


For simple table options, see [[Table]].



'''Examples'''

[[File:Tabela Cruzada 4+en-US.PNG]]

The above example shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized 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''.


'''Data Properties'''

* [[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]]
* [[Row limit|Row Limit]]
* [[Show Pager]]


'''Header Properties'''

* [[Header Properties]]


'''Title Bar Properties'''

* [[Title bar Properties]]


'''Layout Properties'''

* [[Sequence column|Sequence Column]]
* [[Alternate row colors|Alternate Row Colors]]
* [[Hide Border|Show Border]]
* [[Border color|Border Color]]
* [[Grid line color|Grid Line Color]]
* [[Object positions|Object Positions]]
* [[Object dimensions|Object Dimensions]]


'''Object Columns Properties'''

''Data Properties''
* [[Selected column]]
* [[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''
* [[Column width|Column Width]]
* [[Column font|Column Font]]
* [[Column font size|Column Font Size]]
* [[Column background color|Column Background Color]]
* [[Column font color|Column Font Color]]
* [[Column font style|Font Style]]
* [[Text alignment|Text Alignment]]