Build 4.0.0.99 of xlsgen adds a new member to aggregation functions in pivot tables. This member is "aggrpivotfunction_none" and what it allows to do is ask the pivot table engine to avoid displaying subtotals in row/column/page fields.

Here is a sample source code (C++) :

xlsgen::IXlsEnginePtr engine( __uuidof(xlsgen::CoXlsEngine) );

xlsgen::IXlsWorkbookPtr wbk = engine->New( L"output.xlsx" );

xlsgen::IXlsWorksheetPtr wksht = wbk->AddWorksheet( L"Sheet1" );

wksht->Cell[3][2]->HtmlLabel = L"<font color=#000000 size=11 name=\"Calibri\">s1</font>";
wksht->Cell[3][3]->HtmlLabel = L"<font color=#000000 size=11 name=\"Calibri\">s2</font>";
wksht->Cell[3][4]->HtmlLabel = L"<font color=#000000 size=11 name=\"Calibri\">s3</font>";
wksht->Cell[4][2]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">1</font>";
wksht->Cell[4][3]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">2</font>";
wksht->Cell[4][4]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">3</font>";
wksht->Cell[5][2]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">5</font>";
wksht->Cell[5][3]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">2</font>";
wksht->Cell[5][4]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">3</font>";
wksht->Cell[6][2]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">4</font>";
wksht->Cell[6][3]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">2</font>";
wksht->Cell[6][4]->HtmlFloat = L"<font color=#000000 size=11 name=\"Calibri\">3</font>";

xlsgen::IXlsPivotTablePtr pt = wksht->NewPivotTable();
pt->DataSource->Range = L"R3C2:R6C4";

xlsgen::IXlsPivotTableFieldPtr pf1 = pt->Rows->AddByName(L"s1");
pf1->AggregateFunction = xlsgen::aggrpivotfunction_none;

pt->Rows->AddByName(L"s2");
pt->Data->AddByName(L"s3");

pt->InsertAt(3,8);

wbk->Close();