pvtTbl.SortRowKeysByColumnKey(new ValueKey( "Android APP"), 0, ListSortDirection.Ascending);

But I hope is

I hope is

I write code is

        pvtHtmlWr.TotalsColumn = false;
        pvtHtmlWr.TotalsRow = false;
        pvtHtmlWr.GrandTotal = false;

but is

if I write code is

        pvtHtmlWr.TotalsColumn = true;
        pvtHtmlWr.TotalsRow = true;
        pvtHtmlWr.GrandTotal = ture;

User does not check Totals

I'm using the PivotTableHtmlWriter but when I have too much data, the rending takes forever.

I found SliceQuery but it's only to filter data.

Thank you very much

When nothing is aggregated (count=0) default value is 0, which is definitely wrong for 'avg'.
Lets make default values consistent with SQL AVG/SUM: they are NULL in this case.

This should also affect state deserialization: if loaded value is NULL, this means that this is 'empty' aggregation and count also should be 0.

Normally IPivotData enumerator iterates only by 'real' data points (= where dimension keys are real values) and PivotTable.RowKeys / PivotTable.ColumnKeys calculation works well. However, there is a specific case when totals are mixed with normal entries - for example, when totals are calculated outside (say, on DB side) and then just loaded into IPivotData instance as described here. These 'totals' data points are processed in PivotTable class and lead to undesired excessive RowKey / ColumnKeys entries. To avoid that IPivotData needs to be wrapped with a special proxy that skips 'totals' data points (aka SkipTotalsPivotDataWrapper).

It makes sense to handle 'totals' entries inside PivotTable RowKeys/ColumnKeys calculation (to avoid need in SkipTotalsPivotDataWrapper); this change should not break anything.

Is this library maintained? Was it updated to .NET 6?

PivotTableHtmlWriter support Subtotal .

        var outputWr = new StringWriter();
        var pvtHtmlWr = new PivotTableHtmlWriter(outputWr);
        pvtHtmlWr.SubtotalRows = true;
        pvtHtmlWr.SubtotalDimensions = new string[] { "Date" };
        pvtHtmlWr.SubtotalColumns = true;