Category: Form Pivot

Right click anywhere on the Chart, click the Invoke Wizard option.

Right click on the header, select the Show Chart option.

Right click on the header, click the Hide Chart option.

or Right click anywhere on the Chart, click the Hide Chart option.

Pivot Forms can perform different calculations against data (for instance, calculating sums, averages, maximum and minimum values, etc.).

To specify which calculations Pivot Form should perform against its data, invoke the Data Field Summary Change Menu by left-clicking a data header and choose the appropriate function type.

Click a filter button displayed in the header of a data field to invoke the Summary Filter Popup.

The summary filter popup window allows end-users to select a range of summary values that should be displayed in the pivot grid.

Start Value and End Value text editors – allow end-users to enter bounds of the selected range from a keyboard.
Range Selector – used to select a range via pointing. For more information, see the Range Selector section below.
Apply to Specific Level check box – if checked, enables the Column Field and Row Field combo boxes. In this instance, an end-user can select an aggregation level to which the filtering will be applied.
Column Field and Row Field combo boxes – allow end-users to select a column and row field that identify an aggregation level to which the filtering will be applied. Enabled if the Apply to Specific Level check box is checked.
Clear button – resets the summary filter.

Use the Range Selector to select a range of summary values that should be displayed in the Pivot Form.

Summary Distribution Diagram – shows the distribution of summary values.
Selection Thumbs – drag to select the range between thumbs.
Viewport Scroll Thumb – drag to move the viewport.
Zoom Grips – use to enlarge or shrink the viewport.
Selection Scroll Thumb – drag to move the selection.

The Summary Distribution Diagram displays the distribution of summary values and indicates which values are already filtered out.

The horizontal axis shows numeric values. They can be decimal or integer, depending on the data type of summary values. By default, the minimum and maximum values on this axis match the smallest and largest summary values respectively.

The diagram displays bars, whose bases break the horizontal axis into a number of even ranges. The height of each bar indicates the number of summary values that fall into the corresponding range.

Dark blue bar regions correspond to visible summary values, while light blue regions correspond to hidden values.

In addition, the diagram displays two constant lines. The first one indicates the maximum number of summary values that fall into one range (the height of the highest bar). The second one indicates the same number among the visible values (the height of the highest dark blue bar).

To apply filtering to a field, click the filter button in the field header and select the field values that should be displayed in the Pivot Form.

The Prefilter allows you to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators.

Right click a field header area or a field header, and choose ‘Show Prefilter’ from the context menu.

Once the Prefilter has been applied, the Pivot Grid Control shows the Prefilter Panel at the bottom.

To disable/enable the Prefilter, use the check box in the Prefilter Panel.

To edit the Prefilter, use the Edit Prefilter button.

Click the expand/collapse button:

or Right-click the corresponding field value and choose Expand (or Collapse) from the context menu.

To expand or collapse all columns/rows that correspond to the values of a particular field, right-click one of the field values and choose Expand All (or Collapse All) from the context menu.

Drag the field header to a new position in the same area or a different area.

or Right-click the field header and select the required option from the Order submenu to move the field to a new position in the same area.

To toggle the sort order of field values, click the field header.

To sort the values of a column field by a row, or the values of a row field by a column, right-click the row (column) and choose the field whose values should be sorted by the row (column) summaries from the context menu:

Select the Hide item in the field header context menu.

or Drag and drop a field onto the Field List form.

Open the Customization Form, and drag the field header from the Customization Form to the required area within the Pivot Form.

or Select a field in the Customization Form and a Pivot Form area in the drop-down combo box and click the form’s Add To button.

Cells display summary values that have been calculated for row and column fields.

The Column Header Area displays the headers of visible Column fields.

Column fields represent data source fields.

Pivot Form calculates summaries against data fields and summary results displayed within the Data Area.

Data fields represent fields located in a Pivot Form’s data header area.

The Row Header Area displays the headers of visible Row fields.

Row fields represent data source fields that are located in a Pivot Form’s row header area

The Filter Header Area displays the headers of visible Filter fields.

Filter fields represent data source fields which are located in a Pivot Form’s filter header area.

Filter fields allow end-users to apply filtering to the entire Pivot Form to display data for the predefined values.