Grid forms

Improve the visual representation of your data to make it easier to understand. You can use the forms of a pivot table to display the report differently.

WebDataRocks Pivot Table offers three standard layouts – classic, compact and flat forms.

To change the grid form

Via UI
1. Go to the Options tab () on the Toolbar.
2. Select the form of your choice.
3. Apply the changes.
Programmatically
Set a grid layout through the grid.type property of the Options Object:
```
const report = {
  options: {
    grid: {
      type: "classic"
    }
  }
};
```
It is also possible to set the grid.type option for all reports.

Compact form

The compact form is enabled by default. This layout helps keep your data in a neat and concise style.

Features:

Compact form enhances the readability of the report.
If the rows contain more than one hierarchy, the members of the inner hierarchy can be expanded and collapsed by clicking on the outer hierarchy name.
If the members of the hierarchies in the rows are expanded, they are placed one under the other, without being transferred to a separate column.
If the members of the hierarchies in the columns are expanded, they are placed in a separate row.
Subtotals are shown at the end of each row in a separate column.
Grand totals are placed at the bottom in a separate row.

Classic form

The classic form suits perfectly those who would like to have an Excel-like user experience.

Features:

If the rows contain more than one hierarchy, the members of the inner hierarchy can be expanded and collapsed by clicking on the outer hierarchy name.
If the members of the hierarchies in the rows are expanded, they are placed in a separate column. It is the main feature that distinguishes the classic layout from the compact one.
If the members of the hierarchies in the columns are expanded, they are placed in a separate row.
Subtotals are shown in a separate row after each hierarchy in the rows.
Grand totals are placed at the bottom in a separate row.

Flat form

The flat form displays the data in a non-aggregated view which reflects its original raw structure. It’s the simplest form among the others.

Features:

The data is shown without aggregation.
Each hierarchy is placed in a separate column.
Grand totals are placed in the first row.