Difference between revisions of "Cross Table"
(Marked this version for translation) |
|||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
| + | <!--T:1--> | ||
'''See a [[Tables Tutorial|video tutorial]] about tables'''. | '''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. | 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. | 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. | 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. | 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]]. | For simple table options, see [[Table]]. | ||
| + | <!--T:7--> | ||
'''Examples''' | '''Examples''' | ||
| + | <!--T:8--> | ||
[[File:ctable_ex.png|link=]] | [[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. | 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=]] | [[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''. | 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''' | '''Data Properties''' | ||
| + | <!--T:13--> | ||
* [[Advanced row filter]] | * [[Advanced row filter]] | ||
* [[Column order]] | * [[Column order]] | ||
| Line 40: | Line 53: | ||
| + | <!--T:14--> | ||
'''Title Bar Properties''' | '''Title Bar Properties''' | ||
| + | <!--T:15--> | ||
* [[Title bar Properties]] | * [[Title bar Properties]] | ||
| + | <!--T:16--> | ||
'''Layout Properties''' | '''Layout Properties''' | ||
| + | <!--T:17--> | ||
* [[Alternate row colors]] | * [[Alternate row colors]] | ||
* [[Grid line color]] | * [[Grid line color]] | ||
| Line 54: | Line 71: | ||
| + | <!--T:18--> | ||
'''Object Columns Properties''' | '''Object Columns Properties''' | ||
| + | <!--T:19--> | ||
* [[Column filters]] | * [[Column filters]] | ||
* [[Column label]] | * [[Column label]] | ||
Revision as of 13:30, 2 April 2014
See a 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 run-time cross tables have navigation buttons 
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 
and displays information 
about current and total rows.
For simple table options, see Table.
Examples
The above example, shows a cross table of Group (row) by Year (column) and the summarized ammount of Cost and Profit for these crossings.
The second example, shows a Product by Weekday Gross Sales with the option to dynamic filter the object's data by Year and Month.
Data Properties
Title Bar Properties
Layout Properties
Object Columns Properties
