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.6.1

Syntax

C++

Copy

public class DifferencePivotTable : IPivotTable

Public Class DifferencePivotTable
	Implements IPivotTable

public ref class DifferencePivotTable : IPivotTable

type DifferencePivotTable =  
    class
        interface IPivotTable
    end

The DifferencePivotTable type exposes the following members.

Constructors

	Name	Description
	DifferencePivotTable(IPivotTable, DifferencePivotTableDifferenceMode)	Initializes a new instance of DifferencePivotTable instance by specified IPivotTable and difference mode.
	DifferencePivotTable(IPivotTable, DifferencePivotTableDifferenceMode, Int32)	Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, difference mode and measure index.
	DifferencePivotTable(IPivotTable, FuncPivotTableValueContext, IAggregator, Int32)	Initializes a new instance of DifferencePivotTable instance by specified IPivotTable, custom "from" value provider and measure index.

Top

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

Top

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.)

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

Copy

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

Reference

NReco.PivotData Namespace