Vizlib Home Try Vizlib
Welcome
Login

Vizlib Pivot Table Properties - Dimensions

TABLE OF CONTENTS


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


Tooltip


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

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.