Page History

...

Introducedin

	8.4

...


	8.4

Description

Excerpt
Sets or returns the type of calculation used to summarize a data field. The available types are determined by `PivotTableField.SummarizeByType`.

Signature

	C#
	C#

 public SummarizeByType SummarizeBy{ get; set; }
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public Property SummarizeBy() As SummarizeByType
{signature}
{example}{code:csharp|title=C#}

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} {code:vbnet|title=

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

{code} {example} {remarks} Data fields are set to

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

|EW8:PivotTableField.IsValuesLabel]}}

property

{remarks}

Space Shortcuts

Page tree

Versions Compared

Old Version 23

New Version Current

Key