Show Data As

Additionally to aggregation functions modification functions can be applied to the data field. You can use the attribute “Show data as” for that purpose. One of the following modification functions can be assigned:

Difference From

Displays data as the difference from the value of the Base item in the Base field.

% Of

Displays data as a percentage of the value of the Base item in the Base field.

% Difference From

Displays data as the percentage difference from the value of the Base item in the Base field.

Running Total in

Displays the data for successive items in the Base field as a running total.

% Of Row

Displays the data in each row or category as a percentage of the total for the row or category.

% Of Column

Displays all the data in each column or series as a percentage of the total for the column or series.

% Of Total

Displays data as a percentage of the grand total of all the data or data points in the report.

Index

Calculates data as follows:

((value of the field) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))