Class PivotValue

The definition of how a value in a pivot table should be calculated.

Inheritance

System.Object

PivotValue

Implements

IDirectResponseSchema

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class PivotValue : object, IDirectResponseSchema

Properties

CalculatedDisplayType

If specified, indicates that pivot values should be displayed as the result of a calculation with another pivot value. For example, if calculated_display_type is specified as PERCENT_OF_GRAND_TOTAL, all the pivot values are displayed as the percentage of the grand total. In the Sheets UI, this is referred to as "Show As" in the value section of a pivot table.

Declaration

public virtual string CalculatedDisplayType { get; set; }

Property Value

Type	Description
System.String

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

Formula

A custom formula to calculate the value. The formula must start with an = character.

Declaration

public virtual string Formula { get; set; }

Property Value

Type	Description
System.String

Name

A name to use for the value.

Declaration

public virtual string Name { get; set; }

Property Value

Type	Description
System.String

SourceColumnOffset

The column offset of the source range that this value reads from.

For example, if the source was C10:E15, a sourceColumnOffset of 0 means this value refers to column C, whereas the offset 1 would refer to column D.

Declaration

public virtual Nullable<int> SourceColumnOffset { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

SummarizeFunction

A function to summarize the value. If formula is set, the only supported values are SUM and CUSTOM. If sourceColumnOffset is set, then CUSTOM is not supported.

Declaration

public virtual string SummarizeFunction { get; set; }

Property Value

Type	Description
System.String

Implements

IDirectResponseSchema