The Style tab on the dataset table editing page provides Display Configurations and Total/Subtotal Configurations for formatting cells, fonts, headers, totals, and subtotals.
Display Configuration
Configure the visual appearance of your dataset table.
Custom Block Name
Customize the block name.
A custom name helps locate the block when setting filter conditions, global parameters, or jumps.
Merge Cells Of The Same Type
Merge or unmerge cells of the same type.
Hide Table Header
Show or hide the table header.
Diagonal Header
Diagonal headers support traditional complex report styles. You can create two-part diagonal cells and three-part diagonal cells.
-
Configure diagonal headers on the Style tab.
-
Configure diagonal headers in the toolbar.
NoteIn the toolbar, use an English comma (,) as a line break. For example, the diagonal header in the preceding image uses the input "Region,Product Type,Product Sub-category".
Automatic Column Width
Set columns to automatically adjust width.
Using this feature with many columns might cause performance issues.
Block Style
Block Style lets you configure persistent styles for each block in the dataset table. Styles remain intact when you adjust fields or change filter conditions.
-
Click the
icon to enable Block Style. Then, you can configure the Font Style and Cell Style for different blocks, such as the table header, row header, data area, total, and subtotal.Style setting
Description
Font style
Font, font size, and color
Select the font type, size, and color for the current block.
Font alignment
Select the font alignment within cells for the current block.
Bold, Italic, Strikethrough, and Underline
Set the font for the current block to bold, italic, strikethrough, or underline.
Cell style
Fill color
Set the fill color for the cells in the current block.
Border
Set the border style for the cells in the current block.
-
To quickly apply a configured style to other blocks, click the
icon and select the target blocks from the drop-down list.
-
If you no longer need the current style, click the
icon to clear all existing styles from the block.
Conditional Formatting
Conditional formatting enhances data analysis and readability in workbooks, especially for complex reporting scenarios.
Total/Subtotal Configuration
Configure how data is aggregated in the dataset table.
Configure row totals, row subtotals, column totals, and column subtotals. Typically, configure totals and subtotals for either rows or columns. For mixed row-and-column scenarios, you can configure both.
Display Position
Set the display position for totals and subtotals.
-
If you configure Row Total/subtotal, the supported display positions are Left and Right.
-
If you configure Column Total/subtotal, the supported display positions are Bottom and Top.
Overall Summary
Configure the overall summary for rows or columns.
Example of a column summary:
-
Customize the alias for the total.
-
Set the calculation method for the field total: use automatic calculation, or select a custom function such as SUM, AVG, MAX, or COUNT.
-
Set a custom calculation method for each individual field.
Subtotal by Category
Set a subtotal alias, select a summary dimension, choose a subtotal function, and add multiple subtotal fields.
FAQ
Why does the table not change after I set the automatic column width?
The column width is already set to automatic. No visible change occurs when the current width matches the automatic setting.