pub struct PivotGroup {
pub data_source_column_reference: Option<DataSourceColumnReference>,
pub group_limit: Option<PivotGroupLimit>,
pub group_rule: Option<PivotGroupRule>,
pub label: Option<String>,
pub repeat_headings: Option<bool>,
pub show_totals: Option<bool>,
pub sort_order: Option<String>,
pub source_column_offset: Option<i32>,
pub value_bucket: Option<PivotGroupSortValueBucket>,
pub value_metadata: Option<Vec<PivotGroupValueMetadata>>,
}
Expand description
A single grouping (either row or column) in a pivot table.
This type is not used in any activity, and only used as part of another schema.
Fields§
§data_source_column_reference: Option<DataSourceColumnReference>
The reference to the data source column this grouping is based on.
group_limit: Option<PivotGroupLimit>
The count limit on rows or columns to apply to this pivot group.
group_rule: Option<PivotGroupRule>
The group rule to apply to this row/column group.
label: Option<String>
The labels to use for the row/column groups which can be customized. For example, in the following pivot table, the row label is Region
(which could be renamed to State
) and the column label is Product
(which could be renamed Item
). Pivot tables created before December 2017 do not have header labels. If you’d like to add header labels to an existing pivot table, please delete the existing pivot table and then create a new pivot table with same parameters. +–––––––+———+—––+ | SUM of Units | Product | | | Region | Pen | Paper | +–––––––+———+—––+ | New York | 345 | 98 | | Oregon | 234 | 123 | | Tennessee | 531 | 415 | +–––––––+———+—––+ | Grand Total | 1110 | 636 | +–––––––+———+—––+
repeat_headings: Option<bool>
True if the headings in this pivot group should be repeated. This is only valid for row groupings and is ignored by columns. By default, we minimize repetition of headings by not showing higher level headings where they are the same. For example, even though the third row below corresponds to “Q1 Mar”, “Q1” is not shown because it is redundant with previous rows. Setting repeat_headings to true would cause “Q1” to be repeated for “Feb” and “Mar”. +–––––––+ | Q1 | Jan | | | Feb | | | Mar | +––––+—–+ | Q1 Total | +–––––––+
show_totals: Option<bool>
True if the pivot table should include the totals for this grouping.
sort_order: Option<String>
The order the values in this group should be sorted.
source_column_offset: Option<i32>
The column offset of the source range that this grouping is based on. For example, if the source was C10:E15
, a sourceColumnOffset
of 0
means this group refers to column C
, whereas the offset 1
would refer to column D
.
value_bucket: Option<PivotGroupSortValueBucket>
The bucket of the opposite pivot group to sort by. If not specified, sorting is alphabetical by this group’s values.
value_metadata: Option<Vec<PivotGroupValueMetadata>>
Metadata about values in the grouping.
Trait Implementations§
Source§impl Clone for PivotGroup
impl Clone for PivotGroup
Source§fn clone(&self) -> PivotGroup
fn clone(&self) -> PivotGroup
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read moreSource§impl Debug for PivotGroup
impl Debug for PivotGroup
Source§impl Default for PivotGroup
impl Default for PivotGroup
Source§fn default() -> PivotGroup
fn default() -> PivotGroup
Source§impl<'de> Deserialize<'de> for PivotGroup
impl<'de> Deserialize<'de> for PivotGroup
Source§fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
Source§impl Serialize for PivotGroup
impl Serialize for PivotGroup
impl Part for PivotGroup
Auto Trait Implementations§
impl Freeze for PivotGroup
impl RefUnwindSafe for PivotGroup
impl Send for PivotGroup
impl Sync for PivotGroup
impl Unpin for PivotGroup
impl UnwindSafe for PivotGroup
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
Source§impl<T> Instrument for T
impl<T> Instrument for T
Source§fn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
Source§fn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
Source§impl<T> IntoEither for T
impl<T> IntoEither for T
Source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
self
into a Left
variant of Either<Self, Self>
if into_left
is true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read moreSource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
self
into a Left
variant of Either<Self, Self>
if into_left(&self)
returns true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read more