Difference between revisions of "Cross Table"
| Line 15: | Line 15: | ||
<!--T:5--> | <!--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 | + | 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. |
| Line 30: | Line 30: | ||
<!--T:9--> | <!--T:9--> | ||
| − | The above example | + | The above example shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized amount of ''Cost'' and ''Profit'' for these crossings. |
| Line 37: | Line 37: | ||
<!--T:11--> | <!--T:11--> | ||
| − | The second example | + | 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''. |
Revision as of 13:51, 24 October 2016
Watch a 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 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 to display 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 amount of Cost and Profit for these crossings.
The second example shows a Product by Weekday Profit with the option to dynamic filter the object's data by Year and Month.
Data Properties
Title Bar Properties
Header Properties
Layout Properties
- Alternate row colors
- Border color
- Grid line color
- Object dimensions
- Sequence column
- Object positions
Object Columns Properties
