Page 50 - Unanet AE: Using Analytic Dashboard Designer

To transpose the selected Pivot dashboard item, use the Transpose button in the
Home ribbon tab.

Conditional Formatting
Once data is added to the pivot, it can be formatted in a variety of ways to help visualize
otherwise static data points, highlighting cells that meet certain defined criteria.
A Pivot dashboard item applies conditional formatting to cell values. You can calculate a
format rule by measures placed in the Values section and dimensions placed in the
Columns or Rows section. Note that you can use hidden measures to specify a
condition used to apply formatting to visible values.

Pivot Tools and Design
Pivots feature a specific set of design and data tools, available from the toolbar (some
options are also available by right-clicking the pivot).

Common Group
• Show Caption: To show or hide the caption of a dashboard item, click the Show
Caption button.
• Edit Names: This is an alternate location for editing names of the columns and
grid.

Initial State
• Sets the default state of grid hierarchy (expanded or not). Expanding the columns
may result in a much wider table.

Layout Group
• Totals: Shows/Hides row and/or column totals.
• Grand Totals: Shows/Hides grand totals.
• Layout: If the Pivot dashboard item contains a hierarchy of dimensions in the
Rows section, you can specify the layout (Tabular or Compact) used to arrange
values corresponding to individual groups.
• Row Totals Position: If necessary, you can change the Pivot dashboard item’s
totals/grand totals position.

Lesson 2: Dashboard Design ©2024 Unanet. All rights reserved. 50