Class PivotValue

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

Inheritance

System.Object

PivotValue

Implements

Google.Apis.Requests.IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class PivotValue : 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

[JsonProperty("calculatedDisplayType")]
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

[JsonProperty("formula")]
public virtual string Formula { get; set; }

Property Value

Type	Description
System.String

Name

A name to use for the value.

Declaration

[JsonProperty("name")]
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

[JsonProperty("sourceColumnOffset")]
public virtual 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

[JsonProperty("summarizeFunction")]
public virtual string SummarizeFunction { get; set; }

Property Value

Type	Description
System.String

Implements

Google.Apis.Requests.IDirectResponseSchema