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 form of the pivot table

  1. Go to the Options tab ( menu_options ).
  2. Select the form of your choice.

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. 

Next step

Focus your attention on the values that matter most by using the conditional formatting feature.