Changes

Jump to: navigation, search

Cross Table

219 bytes added, 13:30, 2 April 2014
Marked this version for translation
<translate>
<!--T:1-->
'''See a [[Tables Tutorial|video tutorial]] about tables'''.
<!--T:2-->
A table like 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 [[Date]] or [[Text]] 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: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.
<!--T:6-->
For simple table options, see [[Table]].
<!--T:7-->
'''Examples'''
<!--T:8-->
[[File:ctable_ex.png|link=]]
<!--T:9-->
The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings.
<!--T:10-->
[[File:ctable_ex2.png|link=]]
<!--T:11-->
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''.
<!--T:12-->
'''Data Properties'''
<!--T:13-->
* [[Advanced row filter]]
* [[Column order]]
<!--T:14-->
'''Title Bar Properties'''
<!--T:15-->
* [[Title bar Properties]]
<!--T:16-->
'''Layout Properties'''
<!--T:17-->
* [[Alternate row colors]]
* [[Grid line color]]
<!--T:18-->
'''Object Columns Properties'''
<!--T:19-->
* [[Column filters]]
* [[Column label]]

Navigation menu