## PivotField::SetSubtotals(PivotFieldSubtotalType, bool) method


Sets how to subtotal the specified field.

```cpp
void Aspose::Cells::Pivot::PivotField::SetSubtotals(PivotFieldSubtotalType subtotalType, bool shown)
```


| Parameter | Type | Description |
| --- | --- | --- |
| subtotalType | PivotFieldSubtotalType | [PivotFieldSubtotalType](../../pivotfieldsubtotaltype/) |
| shown | bool | Whether the specified field shows that subtotals. |

## See Also

* Class [Vector](../../../aspose.cells/vector/)
* Enum [PivotFieldSubtotalType](../../pivotfieldsubtotaltype/)
* Class [PivotField](../)
* Namespace [Aspose::Cells::Pivot](../../)
* Library [Aspose.Cells for C++](../../../)
## PivotField::SetSubtotals(PivotFieldSubtotalType) method


Gets or sets the subtotals of the field. Only for [Row](../../../aspose.cells/row/) or [Column](../../../aspose.cells/column/) pivot field.

```cpp
void Aspose::Cells::Pivot::PivotField::SetSubtotals(PivotFieldSubtotalType value)
```


## Examples


```cpp
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

* Class [Vector](../../../aspose.cells/vector/)
* Enum [PivotFieldSubtotalType](../../pivotfieldsubtotaltype/)
* Class [PivotField](../)
* Namespace [Aspose::Cells::Pivot](../../)
* Library [Aspose.Cells for C++](../../../)
