Show average on Values SmartColumn summary row

Summary row values in Values SmartColumns can be shown as an average of lower-level values, instead of a sum of lower-level values.

Display summary row values as an average:

1. Double-click the Values SmartColumn heading.

2. Choose the Column Type (SmartColumn) Settings tab.

3. Choose Properties.

4. When shown on Summary Bar, show average instead of total.

   This setting overrides the Compute Rolled-up Values for Value/Calc SmartColumns setting which may also be checked (under Layout | Other | Summary Bar Settings).