Difference between revisions of "Cross Table"

From TaticView
Jump to: navigation, search
Line 15: Line 15:
  
 
<!--T:5-->
 
<!--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: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 displays information [[File:Tabela Cruzada 3+en-US.PNG]] about current and total rows.
  
  
Line 27: Line 27:
  
 
<!--T:8-->
 
<!--T:8-->
[[File:ctable_ex.png|link=]]
+
[[File:Tabela Cruzada 4+en-US.PNG]]
  
 
<!--T:9-->
 
<!--T:9-->
Line 34: Line 34:
  
 
<!--T:10-->
 
<!--T:10-->
[[File:ctable_ex2.png|link=]]
+
[[File:Tabela Cruzada 5+en-US.PNG]]
  
 
<!--T:11-->
 
<!--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 Profit'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
  
  

Revision as of 13:34, 17 July 2015

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 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 Tabela Cruzada 2+en-US.PNG and displays information Tabela Cruzada 3+en-US.PNG about current and total rows.


For simple table options, see Table.


Examples

Tabela Cruzada 4+en-US.PNG

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


Tabela Cruzada 5+en-US.PNG

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


Object Columns Properties