Settings
The Pivot Table Settings section provides you with options to control the structure and design of the Pivot Table.
 | - Height
Define the height of the Pivot Rows (positioned left).
- Indent Row
Select if you wish the second level of a pivot table to be indented in a hierarchical view, or to be displayed as a separate column right next to it.
|
 | - Always fully expanded
This options fully expands all the left dimensions and hide the collapsable icons.
|
 | |
 | - Column Size
Define the size of the columns in the Pivot Table.
- Left Dim Size
Define how much space the dimensions positioned on the left in the Pivot Table will have in total.
|
Columns/ Rows Definition
The "Columns/Rows definition" section styles the dimension/measure buttons in the Vizlib Pivot Table.
 | Visibility
- Show all measure values.
- Show/ Hide Column definition.
- Show/ Hide Rows definition.
|
 | Definition Styling
- Define the Navigation Area Background color.
- Define the Button Background Color.
- Define the Button Color.
|
 | - Enable Button Borders.
- Choose the Borders' Color.
- Define the Borders' Radius.
- Use the slider to set the Borders' Size.
|
Header Cells
This section styles the header of the top positioned dimensions in the Vizlib Pivot Table.
Header Settings
- Use the Slider to define the Header Row Height.
- Choose between left and right Expand Button Position.
|  |
Rows (Left) Cells
This section styles values of the left positioned dimensions.
Column Settings
- Choose between left and right Expand Button Position.
|  |
Columns (Right) Cells This section styles values of the right positioned measure values.
Zero Values
- Define the Zero Values' Background Color (color- picker or by expression).
- Define the Zero Values' Font Color (color- picker or by expression).
|  |
Totals
This section styles the totals.
 | Position
- Choose between Top/Left and Bottom/ Right Totals Position.
|
  | Totals Styling
- Switch from Auto Mode to Custom Styling.
- Choose the Background color (color- picker or by expression).
- Define the Font Color (color- picker or by expression).
- Set the Font Size (slider or by expression).
- Choose the Font Style (Bold, Italic, underlined).
|
