public DataTable PreparePivotTable(DataTable dataSource, string colX, string colY, string colValue, PivotGroupFunction valueGroupFn = PivotGroupFunction.None) { ColumnX.Name1 = colX; ColumnY.Name1 = colY; ColumnValue = colValue; ValueGroupFunction = valueGroupFn; return(PreparePivotTable(dataSource)); }
public double GetCellData(PivotValue pv, PivotGroupFunction grpFn) { switch (grpFn) { case PivotGroupFunction.Count: return(pv.Count); case PivotGroupFunction.Sum: return(pv.Sum); case PivotGroupFunction.Max: return(pv.Max); case PivotGroupFunction.Min: return(pv.Min); case PivotGroupFunction.Average: case PivotGroupFunction.None: default: return(pv.Average); } }