Header fill color

Lets you select a background color for the header row in a table. If you select Default , no color is used.

If you select both a Header Row fill color and a Header Column fill color, the Header Row takes precedence.

Header font color

Lets you select the text color for the column names in your table header row. This color takes precedence over the table font color applied in General > Font Color , so if you set the general font color to blue and the header row font color to red, the header row font color would appear red instead of blue. If you then chose Default , the header row color would revert to blue.

Header alignment

Lets you select the alignment for the column names in a table header row. The default setting is Left .

In the example, the column names are centered.

If you specify both a Header Row alignment and a Header Column alignment, the Header Row alignment takes precedence.

In the example below, the column names are centered.

Header font style

Lets you select the font style for the column names in a table header row, either bold, italic, bold-italic, or underline. The default setting is Bold .

In the example, Bold-Italic is set as the font style.

Lets you set the height for the header row in a Flex Table (the row containing the column names). A minimum value of 28 is required. There is no maximum limit.

—

Show total row

You must check this box to enable additional total row properties.

Show Total Row lets you add a Grand Total row to the bottom of a table. In this row, all value columns are summed and all string and date/time columns are counted.

Note that the label appears at the bottom of the first column, replacing any total information that would otherwise appear there, so we don’t recommend making the column you want to total the first column.

Label

Lets you replace the “Grand Total” text in your table’s total row with custom text.

—

Total row fill color

Lets you select a background color for the total row in your table. If you select Default , no color is used.

Total row font color

Lets you select the text color for the content in your table’s total row. This color takes precedence over the table font color applied in General > Font Color , so if you set the general font color to blue and the total row font color to red, the total row font color would appear red instead of blue. If you then chose Default , the total row color would revert to blue. Otherwise, the default is black.

Total row font style

Lets you select the font style for the column names in a table total row, either bold, italic, bold-italic, or underline. The default setting is Bold . This option is only available when the Total Row > Show Total Row box is checked.

In the example, Bold-Italic is set as the font style.

Total row position

Lets you specify whether your total row appears at the end of your table (default) or at the beginning.

Total row padding

Lets you add padding, in pixels, between the content in the total row of your mega table and the upper border.

In the example, this value has been set to 25.

Show subtotal rows

You must check this box to enable additional subtotal rows properties.

Lets you add subtotal rows after each group of like values in your table’s first column. In this row, all value columns are summed and all string and date/time columns you added to the Values field are counted.

One subtotal row displays for each of the primary Rows groupings in your table.

In the example, the first column includes state names, which are sorted alphabetically. There are three rows for New Mexico. Therefore, a subtotal column appears after the New Mexico rows, providing subtotals just for the New Mexico data.

Show as percent of total

When this box is checked, subtotals in a table will appear as percent of total values for the entire column instead of the usual subtotals.

Subtotal label

Lets you customize the label text for your table’s subtotal rows. Note that your custom text replaces only the word “Total,” not the name of the group of like values the subtotal is based on.

For example, if the group of like values was “Minnesota” and you added “Summary” as the label text, the label would read “Minnesota Summary.”

You can specify whether your custom label comes before or after the group name using the Subtotal Row > Label Position option.

—

Subtotal label position

Lets you specify whether the word “Total” (or your custom label if you specified one in the Subtotal Row> Label property) comes before or after the name of the group of like values the subtotal row is based on in a table. The default is After .

For example, if the group name was “Minnesota,” by default the label would read “Minnesota Total.” If you changed this setting to Before , the label would read “Total Minnesota.”

—

Subtotal row fill color

Lets you select a background color for the subtotal rows in your table. If you select Default , no color is used.

Subtotal row font color

Lets you select the text color for the content in your table’s subtotal rows. This color overrides the table font color applied in General > Font Color , so if you set the general font color to blue and the subtotal row font color to red, the subtotal row font color would appear red instead of blue. If you then chose Default , the subtotal row color would revert to blue.

Subtotal row font style

Lets you select the font style for the text in your table’s subtotal rows (bold, italic, bold-italic, or underline). The default setting is Bold .

In the example, Bold-Italic is set as the font style.

Show all group names

When checked, for unaggregated data in Mega and Pivot tables, names are shown for all individual items within a category. When unchecked, the category name is only used once (aside from the subtotal row), and blank cells appear under that name for all remaining values in the category.

The first example shows a table in which the customer name appears every time a value is listed for that customer.

The second example shows the same table with customer names only being listed once; all subsequent values for the customer have a blank customer name.

Subtotal row padding

Lets you add padding, in pixels, between the content in the subtotal rows and the lower table border. In the example, this value has been set to 25.

Hide counts

Lets you hide “Count” summations for non-value columns in subtotal rows.

—

Subtotal row position

Lets you specify whether subtotal rows in your table appear after the rows they apply to (default) or before, at the top of each grouping.

Show subheader rows

Lets you add subheader rows above the groupings in your unaggregated data rows in your mega table. If you want to incorporate subheader rows in your table, we recommend that you set them apart using the Subheader fill color , Subheader font color , and/or Subheader f ont style properties so users can see them easily.

—

Subheader fill color

Lets you add a selected background color to the subheader rows in your mega table. (Subheader rows must be turned on using the Subtotal Row > Show Subheader Rows checkbox for this to be available.) By default, no background color is used.

In the example, the subheader rows are shown with an orange background.

Subheader font color

Lets you select a color for the text in the subheader rows in your mega table. (Subheader rows must be turned on using the Subtotal row > Show subheader rows checkbox for this to be available.) By default, the color is black.

In the example, the subheader rows display in red text.

Subheader font style

Lets you select a style (bold, italic, or both) to the text in the subheader rows. (Subheader rows must be turned on using the Subtotal Row > Show Subheader Rows checkbox for this to be available.) By default, no style is applied.

In the example, the subheader rows are shown in bold and italic styling.

Suppress single items subtotals

Lets you determine whether to suppress (hide) subtotals if there is only one item in a group in your table.

—

Graph Settings > Type

Lets you choose the graph type in the column containing your series graphs in your Flex table. Note that these will all be the same graph type for each series; you cannot include more than one type of graph in the same Flex table.

The following graph types are available:

Graph Settings > Bar Width Percentage

Lets you specify the width of the bars in your Flex table as a percentage of the cell space. Not available when you select Line as your graph type.

The screenshot shows an example of a horizontal bar graph in which this setting has been set to 25 . (In contrast, the preceding example is set to the default value of 50 .)

Lets you set the text alignment (left, center, or right) for all desired columns in your table. Column numbers are based on the table column order going from left to right. For example, the third column from the left would be column 3.

In the example, all columns are set to Center .

Lets you set the font style (bold, italic, bold-italic, or underline) for all desired columns in your table. Note this does not affect text in header rows. Column numbers are based on the table column order going from left to right. For example, the third column from the left would be column 3.

In the example, the two value columns are set to Italic .