Pivot table: overview

Each flexYgrid panel contains a built-in pivot table function that lets you build summarized reports of the data in your current grid panel. Using the cell values of your choice as source values, you can select and apply operators to customize the way these values will be displayed in the table. All data that is shown, and not expressly filtered out of your current flexYgrid panel, will be used in your pivot table.
The resulting pivot table grid will display aggregation of your data arranged according to the row and column information you have set.

Create Pivot Table

The Create Pivot Table command is found in both the toolbar and right-click menu.

Ctrl  +  Shift  +P	Create Pivot Table: This function will launch the Pivot Table Setup dialog where you can select the labels for the columns and rows, as well as set the values to use in building your pivot table. You can also select from different formatting options.

Pivot Table Row and Column Structure

In the example pivot table shown above, an entire server has been analyzed to find the ODS versions of each database. The following characteristics are shown:

The Pivot Table Setup Dialog

The Pivot Table Setup dialog is where you will select which columns to use as Column Labels, which columns to use a Row Labels, and the columns that will define which values to focus on when building your pivot table.

Available Columns

This is a list of currently available columns (properties) that can be used as Column and Row Labels, as well as to define the Values the pivot table will focus on.

'Show hidden columns' : Use this option to include ALL columns in the 'Available Columns' list. By default, only the columns that are set as   'Visible'   in your current flexYgrid panel will be shown. This setting can be saved as part of your Default pivot table configuration.

Filter,  Sort, and  Search  functions are available for this list, as are some right-click menu options.

Label Selection Windows

These windows show the currently selected columns (properties) that have been selected to label Columns and Rows, as well as be the focus Values the will make up the pivot table.

Various formatting options are available uniformly throughout the selection windows, as are some  Grid Tools & Options.

All selectable variables within these windows can be saved as part of your Default pivot table configuration.

Columns to use as Column Labels

This window shows the columns (properties) that are currently selected to be used as Column Labels in your pivot table.

Standard  header formatting  options are available.

The formatting on Column Labels takes place before any calculations in the pivot table and thus, in the case of number values, can affect the way that data is aggregated.

Columns to use as Row Labels

This window shows the columns (properties) that are currently selected to be used as Row Labels in your pivot table.

Standard  header formatting  options are available.

The formatting on Row Labels takes place before any calculations in the pivot table and thus, in the case of number values, can affect the way that data is aggregated.

Columns to use as Values

This window shows the currently selected columns (properties) that your pivot table will use as Values.

You can apply a variety of formatting options, as well as  Unique Index  references to your Values.

Standard filter and search options are also available.

NOTE	Organizational functions: Click on the appropriate arrow to move a column title up or down in a label window. Within the right-click menu:  Move Up  Move Down Please note that moving columns will affect the resulting pivot table; the column order is taken into account when calculating totals and sub-totals.  Remove: Remove the selected row.  Remove All: Remove all rows.

Options

Pivot Table Colors

You may select the colors you wish to use as background cell colors for the corresponding cell types here. These can saved as part of your default pivot table configuration.

Setup and Build