class Google::Apis::SheetsV4::ManualRule
—————+
Central | 106.3 | | Eastern | 151.9 | | Mountain | 17.4 | … -----------
—-
+ | Time Zone | SUM of Population | -----------
——————-+ |
the source data and adjusting the pivot table. -----------
——————-
Note that a similar effect could be achieved by adding a time zone column to
groupName = ‘Central’, items = [‘AL’, ‘AR’, ‘IA’, …]) to a manual group rule.
aggregates population by time zone by providing a list of groups (for example,
9 | … -------
——————-+ could be turned into a pivot table that
Population | -------
——————-+ | AK | 0.7 | | AL | 4.8 | | AR | 2.
aggregates population by state: -------
——————-+ | State | SUM of
buckets with names of your choosing. For example, a pivot table that
Allows you to manually organize the values in a source data column into
def initialize(**args)
def initialize(**args) update!(**args) end
def update!(**args)
def update!(**args) @groups = args[:groups] if args.key?(:groups) end