Struct PivotFilterCriteria

pub struct PivotFilterCriteria {
    pub condition: Option<BooleanCondition>,
    pub visible_by_default: Option<bool>,
    pub visible_values: Option<Vec<String>>,
}

Criteria for showing/hiding rows in a pivot table.

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

Fields

condition: Option<BooleanCondition>

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.

visible_by_default: Option<bool>

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.

visible_values: Option<Vec<String>>

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

Trait Implementations

impl Clone for PivotFilterCriteria

fn clone(&self) -> PivotFilterCriteria

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PivotFilterCriteria

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

Formats the value using the given formatter.

impl Default for PivotFilterCriteria

fn default() -> PivotFilterCriteria

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for PivotFilterCriteria

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for PivotFilterCriteria

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 PivotFilterCriteria