PivotTable.CalculateData

CalculateData()

Calculates pivottable’s data to cells.

public void CalculateData()

Remarks

Cell.Value in the pivot range could not return the correct result if the method is not been called. This method calculates data with an inner pivot cache,not original data source. So if the data source is changed, please call RefreshData() method first.

See Also

• class PivotTable
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells

---

CalculateData(PivotTableCalculateOption)

Calculating pivot tables with options

public void CalculateData(PivotTableCalculateOption option)

Parameter	Type	Description
option	PivotTableCalculateOption

See Also

• class PivotTableCalculateOption
• class PivotTable
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells