Difference between revisions of "Cross Table"
| (22 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | <languages/> | |
| − | |||
| + | <translate> | ||
| + | <!--T:1--> | ||
| + | [[File:mainmenu5.png]] | ||
| + | '''Watch a [[Tables Tutorial|video tutorial]] about tables'''. | ||
| + | |||
| + | |||
| + | <!--T:2--> | ||
| + | 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. | ||
| + | |||
| + | <!--T:3--> | ||
| + | The Cross Table object needs two [[Dates]] or [[Texts]] 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: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. | ||
| + | |||
| + | |||
| + | <!--T:6--> | ||
For simple table options, see [[Table]]. | For simple table options, see [[Table]]. | ||
| + | <!--T:7--> | ||
'''Examples''' | '''Examples''' | ||
| − | [[File: | + | <!--T:8--> |
| + | [[File:Tabela Cruzada 4+en-US.PNG]] | ||
| − | The above example | + | <!--T:9--> |
| + | The above example shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized amount of ''Cost'' and ''Profit'' for these crossings. | ||
| − | [[File: | + | <!--T:10--> |
| + | [[File:Tabela Cruzada 5+en-US.PNG]] | ||
| − | The second example | + | <!--T:11--> |
| + | 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''. | ||
| + | <!--T:12--> | ||
'''Data Properties''' | '''Data Properties''' | ||
| − | + | <!--T:13--> | |
| − | |||
* [[Object Filters|Filters]] | * [[Object Filters|Filters]] | ||
| − | * [[ | + | * [[Conditional Formatting]] |
| − | * [[Rows sort]] | + | * [[Rows sort|Rows Sort]] |
| − | * [[Total column]] | + | * [[Column order|Colum Order]] |
| − | * [[Total row]] | + | * [[Total column|Total Column]] |
| + | * [[Total row|Total Row]] | ||
| + | * [[Advanced row filter|Advanced Row Filter]] | ||
| + | * [[Row limit|Row Limit]] | ||
| + | * [[Show Pager]] | ||
| + | |||
| + | |||
| + | <!--T:20--> | ||
| + | '''Header Properties''' | ||
| + | |||
| + | <!--T:21--> | ||
| + | * [[Header Properties]] | ||
| + | <!--T:14--> | ||
'''Title Bar Properties''' | '''Title Bar Properties''' | ||
| + | <!--T:15--> | ||
* [[Title bar Properties]] | * [[Title bar Properties]] | ||
| + | <!--T:16--> | ||
'''Layout Properties''' | '''Layout Properties''' | ||
| − | * [[Alternate row colors]] | + | <!--T:17--> |
| − | * [[ | + | * [[Sequence column|Sequence Column]] |
| − | * [[ | + | * [[Alternate row colors|Alternate Row Colors]] |
| − | * [[ | + | * [[Hide Border|Show Border]] |
| − | * [[ | + | * [[Border color|Border Color]] |
| − | * [[ | + | * [[Grid line color|Grid Line Color]] |
| + | * [[Object positions|Object Positions]] | ||
| + | * [[Object dimensions|Object Dimensions]] | ||
| + | <!--T:18--> | ||
'''Object Columns Properties''' | '''Object Columns Properties''' | ||
| − | + | <!--T:19--> | |
| − | * [[ | + | ''Data Properties'' |
| + | * [[Selected column]] | ||
* [[Column name]] | * [[Column name]] | ||
| − | * [[Data type]] | + | * [[Data type|Data Type]] |
| − | * [[ | + | * [[Column label|Column Label]] |
| − | |||
* [[Function]] | * [[Function]] | ||
| + | * [[Column filters]] | ||
| + | * [[Conditional Formatting]] | ||
| + | * [[Delete column|Remove Column]] | ||
| + | * [[Decimal places|Decimal Places]] | ||
| + | * [[Thousand sep.|Thousand Sep.]] | ||
* [[Mask]] | * [[Mask]] | ||
| − | * [[ | + | |
| − | * [[Column font]] | + | <!--T:22--> |
| − | * [[Column font | + | ''Styles'' |
| − | * [[Column | + | * [[Column width|Column Width]] |
| − | * [[Column font | + | * [[Column font|Column Font]] |
| − | * [[Column | + | * [[Column font size|Column Font Size]] |
| − | * [[Text alignment]] | + | * [[Column background color|Column Background Color]] |
| + | * [[Column font color|Column Font Color]] | ||
| + | * [[Column font style|Font Style]] | ||
| + | * [[Text alignment|Text Alignment]] | ||
| + | </translate> | ||
Latest revision as of 02:02, 5 October 2022
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
- Filters
- Conditional Formatting
- Rows Sort
- Colum Order
- Total Column
- Total Row
- Advanced Row Filter
- Row Limit
- Show Pager
Header Properties
Title Bar Properties
Layout Properties
- Sequence Column
- Alternate Row Colors
- Show Border
- Border Color
- Grid Line Color
- Object Positions
- Object Dimensions
Object Columns Properties
Data Properties
- Selected column
- Column name
- Data Type
- Column Label
- Function
- Column filters
- Conditional Formatting
- Remove Column
- Decimal Places
- Thousand Sep.
- Mask
Styles
