Dimensions and Measures

Views are based on an existing Data Model; all the Fields are made available to the View, categorized as Dimensions, Measures or Descriptions.

These are then placed in the View Organizer, under Groups, Pivots or Columns. Making these selections define the structure of the View.

Groups:

Groups contain the drill-down structure of the View and the visual order of the Fields.

Pivots:

Pivots create a series of column values based on the selected Fields placed under this section.

Columns:

Columns contain the list of Fields represented in the view that are not grouped.

The Organizer is accessed from the Worksheet Properties menu.

1. In the Settings menu (right panel), click on and select Groups / Columns / Pivots.
2. Click on one of the value within the Groups / Columns / Pivots section and select the desired properties you want to apply to customize the View.
   
   Tip

   To show or hide the Groups , Pivots, Columns sections, click on then on their respective names.