Custom calculations for PivotTable and PivotChart data fields
The following functions are available for custom calculations in data fields.
| Function | Result |
|---|---|
| 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 in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) |