[−][src]Struct google_sheets4::PivotGroup
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
show_totals: Option<bool>
True if the pivot table should include the totals for this grouping.
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
.
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 |
+--------------+---------+-------+````
value_metadata: Option<Vec<PivotGroupValueMetadata>>
Metadata about values in the grouping.
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.
sort_order: Option<String>
The order the values in this group should be sorted.
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 repitition 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 |
+--------------+````
group_rule: Option<PivotGroupRule>
The group rule to apply to this row/column group.
Trait Implementations
impl Part for PivotGroup
[src]
impl Default for PivotGroup
[src]
fn default() -> PivotGroup
[src]
impl Clone for PivotGroup
[src]
fn clone(&self) -> PivotGroup
[src]
fn clone_from(&mut self, source: &Self)
1.0.0[src]
Performs copy-assignment from source
. Read more
impl Debug for PivotGroup
[src]
impl Serialize for PivotGroup
[src]
fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error> where
__S: Serializer,
[src]
__S: Serializer,
impl<'de> Deserialize<'de> for PivotGroup
[src]
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error> where
__D: Deserializer<'de>,
[src]
__D: Deserializer<'de>,
Auto Trait Implementations
impl Send for PivotGroup
impl Unpin for PivotGroup
impl Sync for PivotGroup
impl UnwindSafe for PivotGroup
impl RefUnwindSafe for PivotGroup
Blanket Implementations
impl<T> ToOwned for T where
T: Clone,
[src]
T: Clone,
type Owned = T
The resulting type after obtaining ownership.
fn to_owned(&self) -> T
[src]
fn clone_into(&self, target: &mut T)
[src]
impl<T> From<T> for T
[src]
impl<T, U> Into<U> for T where
U: From<T>,
[src]
U: From<T>,
impl<T, U> TryFrom<U> for T where
U: Into<T>,
[src]
U: Into<T>,
type Error = Infallible
The type returned in the event of a conversion error.
fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>
[src]
impl<T, U> TryInto<U> for T where
U: TryFrom<T>,
[src]
U: TryFrom<T>,
type Error = <U as TryFrom<T>>::Error
The type returned in the event of a conversion error.
fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>
[src]
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]
T: ?Sized,
fn borrow_mut(&mut self) -> &mut T
[src]
impl<T> Borrow<T> for T where
T: ?Sized,
[src]
T: ?Sized,
impl<T> Any for T where
T: 'static + ?Sized,
[src]
T: 'static + ?Sized,
impl<T> Typeable for T where
T: Any,
T: Any,
impl<T> DeserializeOwned for T where
T: Deserialize<'de>,
[src]
T: Deserialize<'de>,