Adding Dimensions and Measures

A list of available fields is provided in the Dimensions and Measures section.

  1. In the Settings menu (right panel), click Dimensions and Measures.

  2. All available fields are categorized in three types: Dimension, Description (user calculated columns / pivots) and Measure. The Groups section represents the data structure of the view and also defines the drill-down structure for worksheets and charts.

    Select the appropriate dimension(s) or measure(s) and place them in the Groups, Columns or Pivots section. You can also add dimensions and measures from Worksheet Properties.

    Note

    Measures can only be placed in the Columns section.

    Tip

    You can add multiple fields at the same time using the Ctrl and Shift keys.

    Example

    The Quantity Sold, Ledger Currency Amount and Margin % measures are dragged and dropped as Columns.