Custom calculations for PivotTable and PivotChart data fields
From Microsoft Office Excel 2003
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)) |