PivotFieldCalculation Enumeration
In This Topic
Specifies the subtotal function.
Members
| Member | Description |
|---|
| DifferenceFrom | The difference from the value of the Base item in the Base field. |
| Index | Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)). |
| NoAdditionalCalculation | No calculation. |
| PercentDifferenceFrom | Percentage difference from the value of the Base item in the Base field. |
| PercentOf | Percentage of the value of the Base item in the Base field. |
| PercentOfColumn | Percentage of the total for the column or series. |
| PercentOfParent | Percentage of the total of the specified parent Base field. |
| PercentOfParentColumn | Percentage of the total of the parent column. |
| PercentOfParentRow | Percentage of the total of the parent row. |
| PercentOfRow | Percentage of the total for the row or category. |
| PercentOfTotal | Percentage of the grand total of all the data or data points in the report. |
| PercentRunningTotal | Percentage of the running total of the specified Base field. |
| RankAscending | Rank smallest to largest. |
| RankDecending | Rank largest to smallest. |
| RunningTotal | Data for successive items in the Base field as a running total. |
Inheritance Hierarchy
java.lang.Object
java.lang.Enum
com.grapecity.documents.excel.PivotFieldCalculation
See Also
