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.4.2
Syntax

public class PercentagePivotTable : IPivotTable

The PercentagePivotTable type exposes the following members.

Constructors

  NameDescription
Public methodPercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode)
Initializes a new instance of PercentagePivotTable instance by specified IPivotTable and percentage mode.
Public methodPercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode, Int32)
Initializes a new instance of PercentagePivotTable instance by specified IPivotTable, percentage mode and measure index.
Public methodPercentagePivotTable(IPivotTable, PercentagePivotTablePercentageMode, Int32)
Initializes a new instance of PercentagePivotTable instance by specified IPivotTable, percentage mode and measure indexes.
Public methodPercentagePivotTable(IPivotTable, FuncPivotTableValueContext, IAggregator, Int32)
Initializes a new instance of the PercentagePivotTable class
Top
Properties

  NameDescription
Public propertyColumnKeys
Public propertyColumns
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 pivot table percentage values. It is possible to specify which measure(s) should be calculated as percents if pivot table has several measures.
Examples

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

Reference