Quick BI:Style Configuration

Display Configuration

You can configure the style of the dataset table.

Custom Block Name

You can customize the block name.

This helps you quickly find the block when you set filter conditions, global parameters, or configure jumps. Merge Cells Of The Same Type

You can merge or unmerge cells of the same type.

Hide Table Header

You can show or hide the table header.

Diagonal Header

Diagonal headers are often used to create traditional, complex report styles. You can create two-part diagonal cells and three-part diagonal cells.

• You can configure diagonal headers on the Style tab.

  

• You can configure diagonal headers in the toolbar.

  

  Note

  When configuring a diagonal header in the toolbar, use an English comma (,) to create a line break. For example, the input for the diagonal header in the preceding image is "Region,Product Type,Product Sub-category".

Automatic Column Width

You can set the automatic column width.

Block Style

In the Block Style section, you can configure styles for each block in the dataset table. This ensures that styles persist even if you adjust fields or change filter conditions. You can perform the following operations.

• 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

Quick BI supports conditional formatting for datasets to enhance data analysis and readability in workbooks. This feature is useful for various complex reporting scenarios.

For more information, see Conditional formatting.

Total/Subtotal Configuration

You can configure how data is calculated in the dataset table.

You can configure row totals, row subtotals, column totals, and column subtotals. Typically, you only need to configure totals and subtotals for either rows or columns. In scenarios that use mixed rows and columns, you can configure both simultaneously.

Display Position

You can configure the display position for row or column 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

You can configure the overall summary for rows or columns.

The following image shows an example of a column summary.

• You can customize the alias for the total.

• You can set the calculation method for the field total. You can use the automatic calculation or select a custom function, such as SUM, AVG, MAX, or COUNT.

• You can also set a custom calculation method for each field.

Subtotal by Category

You can set a subtotal alias, select a summary dimension, set a subtotal function, and add multiple subtotal fields.

FAQ

Why does the table not change after I set the automatic column width?

A: The table does not change because the column width in your workbook is already set to the automatic width.