# Namespace Syncfusion.XlsIO.Implementation.PivotAnalysis

### Classes

Average
Displays the Average of values |

BinaryList
Used to store the row header and column header values as BinaryList. |

CalculationType
Calculation type defines the view for a particular computational object (or value field). |

CountSummary
Computes the count of double or integer values. |

CoveredCellRange
This class defines a set of four integers that define a covered range in the zero-based coordinate system of a PivotTable. |

DecimalTotalSummary
This class is used to computes the sum of decimal values. |

DisplayIfDiscreteValuesEqual
Displays the aggregated value in the PivotComputation column, if all the values are aggregated to be same else the value in PadString property is displayed. |

DisplayOption
Used to provide a list of display option. |

DoubleAverageSummary
This class is used to compute the average of double or integer values. |

DoubleMaxSummary
This class is used to compute the maximum of double or integer values. |

DoubleMinSummary
This class is used to compute the minimum of double or integer values. |

DoubleStDevSummary
This class is used to compute the standard deviation of double or integer values. |

DoubleTotalSummary
This class is used to compute the sum of double or integer values. |

DoubleVarianceSummary
This class is used to compute the variance of double or integer values. |

DynamicPropertyDescriptor
Class that holds the methods for setting the value for the variable. |

ExpressionError
Denotes the different error types. |

ExpressionPropertyDescriptor
Class that illustrates the expression field support along with filtering in PivotEngine. |

ExtensionClass
Class which has a method to determine whether the specified item is in the hidden group collection. |

FieldInfo
Gets the information about the PiovtFields. |

FieldTypes
Enum holding the field types. |

FilterExpression
This class encapsulates the information needed to define a filter. |

FilterHelper
This class encapsulates the support for computing filter values and expressions. |

FilterItemElement
Class that holds different filter items. |

FilterItemsCollection
Class that holds the collection of objects that are filtered. |

GetValueDelegate
Use to get the property value without using reflection. |

GridLayout
Specifies the layout for the Pivot control. |

HiddenGroup
Class used to hold the properties of each hidden group. |

IndexEngine
Index Engine is used to load the collection of data faster than the PivotEngine. It makes use of the "EnableOnDemandCalculations" property. Unlike the PivotEngine, it loads the entire collection of data by including all the values in the list irrespective of Row and Column headers. |

IntTotalSummary
This class is used to compute the sum of integer values. |

ListIndexInfo
Class that holds primarily the information on one row in a PivotTable. Additionally, these calls can be used to hold information on the row/column header structures. |

Max
Displays the maximum value of given values |

Min
Displays the minimum value of given values |

PivotCellInfo
This class provides an information about a specific cell in a PivotTable. |

PivotCellInfos
Gets the information from the Pivot control. |

PivotCellType
Enumerates the possible Pivot cell types. |

PivotComputationInfo
This class holds the information needed for the calculations that appear in a Pivot control. For each calculation seen, there is an associated PivotComputationInfo object that is added to the PivotComputationInfo collection. |

PivotEngine
This class encapsulates pivoting calculation support. To use it, first populate the PivotColumns and PivotRows collections to define the properties being pivoted. Then you populate the PivotCalculations collection to define the values you would like to see populated. |

PivotEngine.CalcSortComparer
This class used for sorting the Pivoted row/column. |

PivotEngine.SortKeys
Class that holds the properties which is used to handle single sort and multi sort in Grid. |

PivotGridConstants
Class that holds different Grid constants. |

PivotItem
Enacapulates the information needed to define a PivotItem, for either a row/column Pivot. |

PivotSchemaChangedArgs
Event argument for the PivotSchemaChangedArgs event. |

PivotSchemaChangedEventHandler
Event handler for the PivotSchemaChangedEventHandler event. |

RowType
Enumeration provides option to select row type. |

SchemaChangeHints
Information on what changes have occurred in the Pivot Schema. |

SortComparer
Class used to compare and sort the given collection. |

StdDev
Displays the standard deviation of given values |

StdDevP
Displays the standard deviation population of given values |

Sum
Displays the sum of values |

SummaryBase
This is an abstract class that defines the necessary functionality to do PivotCalculations. |

SummaryDisplayLevel
Controls whether a summary calculation is to be displayed for all levels or only for the inner-most level. |

SummaryPivotItem
This class is primarily for internal use. It is used to generate the rows and columns that hold summaries of PivotCalculations. |

SummaryType
Enumerates the summary types available for calculations in the Pivot control. If you use the value "Custom" in a ComputationInfo object, then you are required to explicitly set the ComputationInfo.Summary value. |

Variance
Displays the Variance of given values |

VarianceP
Displays the VarianceP of given values |

### Interfaces

IAdjustable
Use this interface to enable shortcut calculations to adjust a summary when an underlying value changes. The idea is to avoid re-computing the summary from scratch. For example, if your summary computes the total of a set of values, you can quickly adjust this computed total when a value changes by subtracting the old value and adding the new value without having to re-compute the total from scratch. Not all types of calculations lend themselves to this shortcut behavior. |