Calculated values
Calculated values are values derived from some kind of aggregated expression, similar to the data shown in cross tables.
Note: Calculated values must be authored in the installed client.
The general idea of calculated values is that they can be included
directly where they are needed, in the
context of a graphical table or in a
text area, to provide information at a
glance. You can specify the settings in the
Calculated value settings (in the visualization
properties dialog). Under
Calculate values using, you select the column and
aggregation method to base your calculated value on.


You can add rules that control the color and font style to make sure
that a value stands out when it falls outside of the specified limits:


For example, in a graphical table, you can define one rule to give the top five items in your data a particular color and another rule to provide a different color for all other rows. See Adding or editing a rule for more information.
Calculated values can be configured to be limited by markings, filtering or expressions like any traditional visualization, or they can be locked to show fixed values using the settings in the Data properties for the Calculated value.
Parent topic: Graphical table