Pivot Table

Captisa Forms Pivot Grid allows you to create a pivot table for multi-dimensional data analysis. Using the Pivot Grid, large amounts of data can be summarized and represented in a cross-tabular format that can be sorted, grouped, and filtered. You can customize the layout of the report based on their analysis requirements using simple drag-and-drop operations. The Pivot Grid also supports drill-down (to view the underlying data for calculated cells), exporting, and data visualization.

Create Pivot Grid

1. Go to form explorer.

2. Select the form you want to create pivot grid, click on the pivot grid button, and wait for the pivot grid form to load.

3. Define Pivot Grid.

1. Filter – Specify which filter definition must be used for the pivot grid.

2. View – Specify which view definition must be used for the drill-down grid.

3. Field Panel – The field panel allows you to manage the displayed data. All you have to do is drag and drop items from Fields to Rows, Columns, or Data panels.

4. Chart Type – Select chart type so data can be displayed in a meaningful way. Captisa charts support side-by-side bar, stacked bar, full stacked bar, line, spline, step line, area, spline area, pie, and a doughnut.

5. Palette – Change the color palette for the chart by selecting a pre-defined palette.

6. Legend Position – The Chart can include a legend – an explanatory component that helps you identify a series. Each series is represented by an item on a Legend. An item marker identifies the series color.

7. Load – Load or refresh pivot grid.

8. Drill Down to the Underlying Data – The Chart can include a legend – an explanatory component that helps you identify a series. Each series is represented by an item on a Legend. An item marker identifies the series color.

4. Click on the Save button.

Drill Down to the Underlying Data

A pivot grid cell value is a summary calculated against a data field for a subset of records. Click on the cell to view underlying data in a grid view.