Vizlib Community

Submit a ticket Sign in
Welcome
Login

Vizlib Pivot Table - Settings

Settings


The Pivot Table Settings sections 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.

  •  Show/ Hide Header. 
  • 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).


Appearance


Cells Text

  • Choose the Horizontal Alignment: left/ middle/ right.
Cells Styling

  • Define the Background Color (color- picker or by expression). 
  • Choose the Font Color (color- picker or by expression). 
  • Set the Font Size ( slider or by expression).
  • Determine the Font Family (choose one or define your own).
  • Choose the Font Style (bold, italic, underlined).
  • Add shadow effects.

Borders

  • Show/ Hide Borders using the switch.
  • Choose the Borders' Color (color- picker or by expression).
  • Define the Borders' Thickness.
Null Cells

  • Define the Null Values Background Color (color- picker or by expression).
  • Define the Null Value 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).
V
Vizlib is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.