The grid can be displayed in different forms to enhance the storytelling of a particular dataset. The WebDataRocks supports 3 types of pivot table layouts: classic, compact, and flat view.

• The compact view is the most convenient and popular way to display a pivot grid. The compact form displays items from different row area fields in one column. Optimizing the use of space on the page, the compact view gives more attention to numeric data and displays the hierarchy as drop-down lists.

• The analog of the compact view for the pivot table is the classic view. It provides the usual Excel-like layout of hierarchies, where sub-levels of hierarchies are shown, one by one, in separate columns. The user can immediately see all members in this form and have a constant overview of the slice structure.

Flat table view

A flat layout is the simplest form and corresponds to a regular table, where the data is presented in a non-aggregated raw form without hierarchies. Such a layout gives a dataset overview with quick access to the full details of each record.

Standard grid functionality is also preserved in the flat view: filtering, sorting, the ability to change the order of columns and rows, and grand total for number values are available through the UI.

Each grid form has its use cases and is better to use in specific cases. You can learn more about their advantages in the grid layout documentation.