Class PivotValue

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

Inheritance

object

PivotValue

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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 editor, 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
string

DataSourceColumnReference

The reference to the data source column that this value reads from.

Declaration

[JsonProperty("dataSourceColumnReference")]
public virtual DataSourceColumnReference DataSourceColumnReference { get; set; }

Property Value

Type	Description
DataSourceColumnReference

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
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
string

Name

A name to use for the value.

Declaration

[JsonProperty("name")]
public virtual string Name { get; set; }

Property Value

Type	Description
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
int?

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
string

Implements

IDirectResponseSchema