Class PivotFilterCriteria

Criteria for showing/hiding rows in a pivot table.

Inheritance

object

PivotFilterCriteria

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 PivotFilterCriteria : IDirectResponseSchema

Properties

Condition

A condition that must be true for values to be shown. (visibleValues does not override this -- even if a value is listed there, it is still hidden if it does not meet the condition.) Condition values that refer to ranges in A1-notation are evaluated relative to the pivot table sheet. References are treated absolutely, so are not filled down the pivot table. For example, a condition value of =A1 on "Pivot Table 1" is treated as 'Pivot Table 1'!$A$1. The source data of the pivot table can be referenced by column header name. For example, if the source data has columns named "Revenue" and "Cost" and a condition is applied to the "Revenue" column with type NUMBER_GREATER and value =Cost, then only columns where "Revenue" > "Cost" are included.

Declaration

[JsonProperty("condition")]
public virtual BooleanCondition Condition { get; set; }

Property Value

Type	Description
BooleanCondition

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

VisibleByDefault

Whether values are visible by default. If true, the visible_values are ignored, all values that meet condition (if specified) are shown. If false, values that are both in visible_values and meet condition are shown.

Declaration

[JsonProperty("visibleByDefault")]
public virtual bool? VisibleByDefault { get; set; }

Property Value

Type	Description
bool?

VisibleValues

Values that should be included. Values not listed here are excluded.

Declaration

[JsonProperty("visibleValues")]
public virtual IList<string> VisibleValues { get; set; }

Property Value

Type	Description
IList<string>

Implements

IDirectResponseSchema