Changes

Jump to: navigation, search

Cross Table/en

2,023 bytes added, 13:35, 2 April 2014
Importing a new version from external source
'''See a [[Tables Tutorial|video tutorial]] about tables'''.


A table like 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 [[Date]] or [[Text]] 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_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.


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



'''Examples'''

[[File:ctable_ex.png|link=]]

The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings.


[[File:ctable_ex2.png|link=]]

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''.


'''Data Properties'''

* [[Advanced row filter]]
* [[Column order]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Total column]]
* [[Total row]]


'''Title Bar Properties'''

* [[Title bar Properties]]


'''Layout Properties'''

* [[Alternate row colors]]
* [[Grid line color]]
* [[Object dimensions]]
* [[Sequence column]]
* [[Object positions]]


'''Object Columns Properties'''

* [[Column filters]]
* [[Column label]]
* [[Column name]]
* [[Data type]]
* [[Decimal places]]
* [[Delete column]]
* [[Function]]
* [[Mask]]
* [[Thousand sep.]]
* [[Column font]]
* [[Column font color]]
* [[Column font size]]
* [[Column font style]]
* [[Column width]]
* [[Text alignment]]
11,677
edits

Navigation menu