Aspose::Cells::Pivot::PivotField::GetSubtotals method

PivotField::GetSubtotals(PivotFieldSubtotalType) method

Indicates whether to show specified subtotal for this pivot field.

bool Aspose::Cells::Pivot::PivotField::GetSubtotals(PivotFieldSubtotalType subtotalType)
ParameterTypeDescription
subtotalTypePivotFieldSubtotalTypeSubtotal type.

ReturnValue

Returns whether showing specified subtotal.

See Also

PivotField::GetSubtotals() method

Gets or sets the subtotals of the field. Only for Row or Column pivot field.

PivotFieldSubtotalType Aspose::Cells::Pivot::PivotField::GetSubtotals()

Examples

Aspose::Cells::Startup();
Workbook book;
Worksheet sheet = book.GetWorksheets().Get(0);
Cells cells = sheet.GetCells();
cells.Get(0, 0).PutValue(u"fruit");
cells.Get(1, 0).PutValue(u"grape");
cells.Get(2, 0).PutValue(u"blueberry");
cells.Get(3, 0).PutValue(u"kiwi");
cells.Get(4, 0).PutValue(u"cherry");
cells.Get(5, 0).PutValue(u"grape");
cells.Get(6, 0).PutValue(u"blueberry");
cells.Get(7, 0).PutValue(u"kiwi");
cells.Get(8, 0).PutValue(u"cherry");

cells.Get(0, 1).PutValue(u"year");
cells.Get(1, 1).PutValue(2020);
cells.Get(2, 1).PutValue(2020);
cells.Get(3, 1).PutValue(2020);
cells.Get(4, 1).PutValue(2020);
cells.Get(5, 1).PutValue(2021);
cells.Get(6, 1).PutValue(2021);
cells.Get(7, 1).PutValue(2021);
cells.Get(8, 1).PutValue(2021);

cells.Get(0, 2).PutValue(u"amount");
cells.Get(1, 2).PutValue(50);
cells.Get(2, 2).PutValue(60);
cells.Get(3, 2).PutValue(70);
cells.Get(4, 2).PutValue(80);
cells.Get(5, 2).PutValue(90);
cells.Get(6, 2).PutValue(100);
cells.Get(7, 2).PutValue(110);
cells.Get(8, 2).PutValue(120);

PivotTableCollection pivots = sheet.GetPivotTables();

PivotTable pivot = pivots.Add(u"=Sheet1!A1:C9", u"A12");
pivot.AddFieldToArea(PivotFieldType::Row, u"fruit");
pivot.AddFieldToArea(PivotFieldType::Column, u"year");
pivot.AddFieldToArea(PivotFieldType::Data, u"amount");

pivot.SetPivotTableStyleType(PivotTableStyleType::PivotTableStyleMedium10);

//Change PivotField's attributes
PivotField rowField = pivot.GetRowFields().Get(0);
rowField.SetDisplayName(u"custom display name");

pivot.CalculateData(PivotTableCalculateOption());

// get
if (rowField.GetSubtotals() != PivotFieldSubtotalType::Average)
{
    // set
    //No subtotals
    rowField.SetSubtotals(PivotFieldSubtotalType::None);
    //Automatic subtotals
    //rowField.SetSubtotals(PivotFieldSubtotalType::Automatic);
    //Single subtotals: Sum
    //rowField.SetSubtotals(PivotFieldSubtotalType::Sum);
    //Multipl subtotals: Sum and count numbers
    //rowField.SetSubtotals(PivotFieldSubtotalType::Sum | PivotFieldSubtotalType::Count);
}

book.Save("out.xlsx");
Aspose::Cells::Cleanup();

See Also