Pivot table wrapper that calculates difference between values (by row or column).
Inheritance Hierarchy
NReco.PivotData.DifferencePivotTable
Namespace: NReco.PivotData
Assembly: NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1
Syntax
The DifferencePivotTable type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | DifferencePivotTable(IPivotTable, DifferencePivotTable.DifferenceMode) |
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable and difference mode.
|
| DifferencePivotTable(IPivotTable, DifferencePivotTable.DifferenceMode, Int32) |
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, difference mode and measure index.
|
| DifferencePivotTable(IPivotTable, Func<PivotTableValueContext, IAggregator>, Int32) |
Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, custom "from" value provider and measure index.
|
Properties
| Name | Description | |
|---|---|---|
 | ColumnKeys | |
| Columns | |
| Percentage |
Flag which indicates whether difference should be presented as percentage (false by default).
|
| PivotData | |
| RoundDigits |
Number of fractional digits in the percentage values.
|
| RowKeys | |
| Rows |
Methods
| Name | Description | |
|---|---|---|
| Equals | (Inherited from Object.) |
 | Finalize | (Inherited from Object.) |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| GetValue | |
| MemberwiseClone | (Inherited from Object.) |
| ToString | (Inherited from Object.) |
Remarks
Examples
PivotTable originalPvtTbl; var diffPvtTbl = new DifferencePivotTable(originalPvtTbl, DifferencePivotTable.DifferenceMode.PreviousColumn);
See Also