Struct google_sheets4::PivotValue

pub struct PivotValue {
    pub formula: Option<String>,
    pub summarize_function: Option<String>,
    pub name: Option<String>,
    pub source_column_offset: Option<i32>,
    pub calculated_display_type: 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

formula: Option<String>

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

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.

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.

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 UI, this is referred to as "Show As" in the value section of a pivot table.

Trait Implementations

impl Clone for PivotValue

fn clone(&self) -> PivotValue

Returns a copy 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 Part for PivotValue

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.