Vizlib Home Try Vizlib

Vizlib Pivot Table Properties - Dimensions



Vizlib Pivot Table supports an unlimited number of Dimensions (Figure 1). You can find dimensions in the Data section of the property panel. To add a dimension, click Add, or Add Alternative to add alternative dimensions. 

Figure 1: Dimensions

When you add a dimension, click the icon to open the dimension settings (Figure 2). You can then enter a dimension Label for the Field, and opt to Include Null Values in the chart. You can set a Limitation on your chart data, choosing from a Fixed number (e.g. the top 10 values), the Exact value, or a Relative value (e.g. only showing values above 50%). You can set a Calculation condition using an expression to determine whether the dimension is displayed in the pivot table, and also set the Dimension Visibility.

Figure 2: Dimension Settings

Back to Contents

Dimension Position - Rows

The Dimension Position can be set to Rows (left) or Columns (top)

If you choose rows (Figure 3) to set the dimension in the left of the pivot table, you can customize the Styling by setting the Background Color, the Font Color, and set the Left Column Width

Figure 3: Dimension Position - Rows

Back to Contents

Dimension Position - Columns

If you choose columns (Figure 4) to set the dimension in the top of the pivot table, you can set the Header Label Position, specify a Row height, customize the Background Color, and the Font Color.

Figure 4: Dimensions Position - Columns


You can enable Tooltip settings (Figure 5) with both columns and rows, choosing to customize Tooltip Content, setting a Tooltip Value, the Tooltip Color and enabling a Search Icon

Figure 5: Tooltip

Back to Contents

Dynamic Styling

Dynamic Styling (Figure 6) allows you to style individual lines within the pivot table.

Figure 6: Dynamic Styling

The dynamic styling settings (Figure 7) allow you to enter a Field expression, a List of Values separated by a specific sign (the default is comma), specify a Separator, customize the Background Color, Font Color, Font Size, Font Style, and Border (Font Color and Border Size). 

Figure 7: Dynamic Styling Settings

Back to Contents

Totals and Formatted Export Settings

If you choose to display Totals (Figure 8) you can set the Total label, and you can also set Formatted Export Settings to Export to Excel. Finally, you can add a new Master item or choose to Delete the dimension from the pivot table. 

Figure 8: Totals and Formatted Export Settings

Back to Contents

Did you find it helpful? Yes No

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