NReco.PivotData.Extensions 1.3.8

PivotData Toolkit (extends NReco.PivotData library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentage, difference, running total, heatmap, topN/pagination), CSV/TSV/JSON/SQL data sources, extract-transform-load (ETL) handlers, keyword-based filter etc.

Install-Package NReco.PivotData.Extensions -Version 1.3.8
dotnet add package NReco.PivotData.Extensions --version 1.3.8
paket add NReco.PivotData.Extensions --version 1.3.8
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Note: without a valid license key, PivotData Toolkit works in TRIAL MODE (with some data size limitations / trial notices).
Online demo:
Usage examples:

v.1.3.8 changes:
- PercentagePivotTable: calculate percentage even for negative base (like in Excel)
- FixedPivotData: added ability to load sub-totals from state (use-case: result of SELECT .. WITH CUBE or MDX query)
- PivotTableFactory: ignore incorrect measure index in "SortByValue"
- CsvSource: correct handling of headers with control symbols (like new line)
- fixed issue with pivot table writers when CompositeAggregatorFactory is configured for one aggregator

v.1.3.7 changes:
- fixed incorrect difference percentage calculation in DifferencePivotTable (now works like in Excel)
- now FixedPivotData uses pregrouped totals if they are present in PivotDataState (the same behavior as in PivotData class)
- now GroupedSourceReader supports all standard aggregator types (CountUnique, Variance etc)
- now it is possible to specify variance value mode (as 2nd parameter) for "Variance" aggregator in PivotDataFactory

Complete changes log:

Version History

Version Downloads Last updated
1.3.8 (current version) 268 9/25/2017
1.3.7 737 7/26/2017
1.3.6 174 6/26/2017
1.3.5 311 3/15/2017
1.3.4 513 2/1/2017
1.3.3 309 12/2/2016
1.3.2 213 10/18/2016
1.3.1 215 9/16/2016