Custom calculations for PivotTable data fields
The following functions are available for custom calculations in value fields. For more information, see Change the summary function or custom calculation for a field in a PivotTable report.
| Function | Result |
|---|---|
| Difference From | Displays values as the difference from the value of the Base item in the Base field.
|
| % Of | Displays values as a percentage of the value of the Base item in the Base field.
|
| % Difference From | Displays values as the percentage difference from the value of the Base item in the Base field.
|
| Running Total in | Displays the value for successive items in the Base field as a running total.
|
| % Of Row | Displays the value in each row or category as a percentage of the total for the row or category. |
| % Of Column | Displays all of the values in each column or series as a percentage of the total for the column or series. |
| % Of Total | Displays values as a percentage of the grand total of all of the values or data points in the report. |
| Index | Calculates values as follows:
((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) |