DifferencePivotTable Class

NReco.PivotData Class Library Documentation
Pivot table wrapper that calculates difference between values (by row or column).
Inheritance Hierarchy

SystemObject
  NReco.PivotDataDifferencePivotTable

Namespace:  NReco.PivotData
Assembly:  NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.4.0.0 (1.4.0.0)
Syntax

public class DifferencePivotTable : IPivotTable

The DifferencePivotTable type exposes the following members.

Constructors

  NameDescription
Public methodDifferencePivotTable(IPivotTable, DifferencePivotTableDifferenceMode)
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable and difference mode.
Public methodDifferencePivotTable(IPivotTable, DifferencePivotTableDifferenceMode, Int32)
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, difference mode and measure index.
Public methodDifferencePivotTable(IPivotTable, FuncPivotTableValueContext, IAggregator, Int32)
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, custom "from" value provider and measure index.
Top
Properties

  NameDescription
Public propertyColumnKeys
Public propertyColumns
Public propertyPercentage
Flag which indicates whether difference should be presented as percentage (false by default).
Public propertyPivotData
Public propertyRoundDigits
Number of fractional digits in the percentage values.
Public propertyRowKeys
Public propertyRows
Top
Methods

  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodGetValue
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top
Remarks

Use this class to calculate difference values. It is possible to specify which measure should be calculated as difference if pivot table has several measures.
Examples

PivotTable originalPvtTbl;
var diffPvtTbl = new DifferencePivotTable(originalPvtTbl, DifferencePivotTable.DifferenceMode.PreviousColumn);
See Also

Reference