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 
• Rows
• Columns
• Highlight / nPrinting

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, and 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, control the width of the column containing Dimension names, setting Left Dim Mode as Pixels or Percentage.

Figure 3: Columns

Back to Contents

Highlight / nPrinting

The final group of settings related to highlighting and nPrinting (Figure 4). You can 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. You can also enable nPrinting Table mode export 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.

Figure 4: Highlight / nPrinting

Back to Contents