Cross Table

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 Profit with the option to dynamic filter the object's data by Year and Month.

Data Properties

• Advanced row filter
• Column order
• Filters
• Row limit
• Rows sort
• Show Pager
• Total column
• Total row

Header Properties

• Header Properties

Title Bar Properties

• Title bar Properties

Layout Properties

• Alternate row colors
• Border color
• 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

Styles

• Column Width
• Column Font
• Column Font Size
• Column Background Color
• Column Font Color
• Font Style
• Text Alignment