Vizlib Home Try Vizlib
Welcome
Login

Vizlib Pivot Table Properties - Pivot Table Settings

Pivot Table Settings provides you with options to control the structure and design of the Vizlib Pivot Table object. 


TABLE OF CONTENTS


Scrollbar


The Scrollbar settings (Figure 1) control the starting point for the horizontal scroll bar within the pivot table.


Figure 1: Scrollbar


Back to Contents



Rows


With the Rows (left) menu (Figure 2), you can set the row Height to Auto or Fixed using the slider, enable a hierarchical view with Indent Row, set the Indent left margin, and have the pivot table set to Always Fully Expanded


Figure 2: Rows


Back to Contents


Columns


You can control the pivot table columns with Columns (Figure 3), setting Stretch Columns to either Fill to width or Size to data, set an automatic Column Size (or have a Custom width using the slider), and control the width of the column containing dimension names, setting Left Dim Mode as Pixels or Percentage.


Figure 3: Columns


Back to Contents



Highlight 


The settings related to highlighting (Figure 4) allow you to choose to Highlight Rows On Hover, Highlight Columns On Hover, choose a setting for Highlighting Dimension Values (Last Level, All Levels or Disabled), and set a color for the Hover Background


Figure 4: Highlight 


Back to Contents


nPrinting / Remove HC


You can enable nPrinting Table mode export (Figure 5) if you'd like to export your data to a table in nPrinting, although this can affect the performance of your pivot table calculations. You can find out more about nPrinting with Vizlib extensions here. There is also a Remove Custom HC button which gives you the option to remove the custom Hypercube. This will convert your existing pivot tables and make them compatible with version 3.0.0 of Vizlib Pivot Table

Note: V3.0.0 of Vizlib Pivot Table has introduced some changes in default behaviour. We've listed them here


Figure 5: nPrinting / Remove Custom HC


If you choose Remove Custom HC you'll be asked to confirm the action as it can't be reversed. 


Figure 6: Remove Custom HC Confirmation


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.