Grouping and computed items
The Chart section contains the ability to add Groups or Computed Items to perform computations directly in the chart. Charts, similar to Pivots, provide a very easy method of adding computations and groupings in the section.
Grouping
Chart items can be grouped together by highlighting multiple items in the chart and selecting the Group Items menu item from the Chart menu. Grouping Chart items adds an asterisk in front of the name of the item in which the items were grouped.
Note
Grouping column items can be renamed to a custom name similar to renaming a total or other item. The column must be ungrouped to show the original column names.
Computed items
Computed items can be leveraged in a chart, where calculations are easily configured. Computed items are added by one of the following methods:
|
Right-click method |
Chart menu method |
|---|---|
|
Right-click in the main Chart window |
Select Add Computed Item from the Chart Menu |
|
Select Add Computed Item |
The syntax for the computed...
