Configuring a dimension

For each Pivot Table dimension, you can configure the label for the dimension, whether to display a summary row or column for the dimension, and rules for refining by the dimension value.

From the Table Layout tab of the Pivot Table edit view, to configure a dimension:

  1. Click the edit icon for the dimension you want to configure.

    The Edit Dimension dialog displays.


    Initial view of the Edit Dimension dialog for a Pivot Table
  2. If the dimension is a date/time attribute, then from the Date/time subset list, select the default date/time subset to display.
    Date/time subset list for a date/time dimension

    By default, Studio selects the largest date/time unit that is available for that attribute.

  3. On the edit dimension dialog, to display a summary row or column for the dimension, check the Enable dimension summaries check box.
  4. Under Label, by default, the summary label is "Summary", and Default is selected.

    To provide a custom label, click Custom, then type the new label into the field.

  5. Use the Attribute Cascade section to configure cascading for the dimension.

    For details on dimension cascading and how to configure it, see Configuring cascading for dimension refinement.

  6. To save the dimension configuration, click Apply.