Page History

Description

Introducedin

	8.34
	8.34

Description

Excerpt
Sets or returns the type of calculation used to summarize a data field. The available types include: Sum, Count, Average, Max, Min, Product, Count, Numbers, StdDev, StdDevp, Var and Varp.are determined by `PivotTableField.SummarizeByType`.

Signature

	C#
	C#

 public SummarizeByType SummarizeBy{ get; set; }

Signature

	vb.net
	vb.net

Public Property SummarizeBy() As SummarizeByType

Example

Code Block

	csharp
	csharp
title	C#



          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
          Worksheet ws = wb.Worksheets[0];
          DataField df = ws.PivotTables[0].DataFields[0];
          df.SummarizeBy = PivotTableField.SummarizeByType.Average;

Code Block

	vbnet
	vbnet
title	vb.net



          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim df As DataField = ws.PivotTables(0).DataFields(0)
          df.SummarizeBy = PivotTableField.SummarizebyType.Average

Remarks

Data fields are set to 'SUM' by default for all data types.

This property cannot be set on values labels and such fields will return SummarizeByType.Sum by default. You can check if a PivotTable field is values label with the IsValuesLabel property

Space Shortcuts

Page tree

Versions Compared

Old Version 3

New Version Current

Key