Struct PivotValue

pub struct PivotValue {
    pub calculated_display_type: Option<String>,
    pub data_source_column_reference: Option<DataSourceColumnReference>,
    pub formula: Option<String>,
    pub name: Option<String>,
    pub source_column_offset: Option<i32>,
    pub summarize_function: Option<String>,
}

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

This type is not used in any activity, and only used as part of another schema.

Fields

calculated_display_type: Option<String>

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.

data_source_column_reference: Option<DataSourceColumnReference>

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

formula: Option<String>

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

name: Option<String>

A name to use for the value.

source_column_offset: Option<i32>

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.

summarize_function: Option<String>

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.

Trait Implementations

impl Clone for PivotValue

fn clone(&self) -> PivotValue

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PivotValue

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for PivotValue

fn default() -> PivotValue

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for PivotValue

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for PivotValue

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Part for PivotValue