PercentagePivotTable Class

NReco.PivotData Class Library Documentation

Pivot table wrapper that calculates percentage values (by grand total, row or column totals).

Inheritance Hierarchy

SystemObject
NReco.PivotDataPercentagePivotTable

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

Syntax

C++

Copy

public class PercentagePivotTable : IPivotTable

Public Class PercentagePivotTable
	Implements IPivotTable

public ref class PercentagePivotTable : IPivotTable

type PercentagePivotTable =  
    class
        interface IPivotTable
    end

The PercentagePivotTable type exposes the following members.

Constructors

	Name	Description
	PercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode)	Initializes a new instance of PercentagePivotTable instance by specified IPivotTable and percentage mode.
	PercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode, Int32)	Initializes a new instance of PercentagePivotTable instance by specified IPivotTable, percentage mode and measure index.
	PercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode, Int32)	Initializes a new instance of PercentagePivotTable instance by specified IPivotTable, percentage mode and measure indexes.
	PercentagePivotTable(IPivotTable, FuncPivotTableValueContext, IAggregator, Int32)	Initializes a new instance of the PercentagePivotTable class

Top

Properties

	Name	Description
	ColumnKeys
	Columns
	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 pivot table percentage values. It is possible to specify which measure(s) should be calculated as percents if pivot table has several measures.

Examples

Copy

PivotTable originalPvtTbl;
var percentPvtTbl = new PercentagePivotTable(originalPvtTbl, PercentagePivotTable.PercentageMode.ColumnTotal);

Reference

NReco.PivotData Namespace