IncludeGroupAggregates
is an option of PivotTable that specifies whether to add rows and columns with group aggregates.
Details
- With the default setting IncludeGroupAggregatesFalse, aggregation summaries are not included.
- With the setting IncludeGroupAggregatesTrue, PivotTable returns a Tabular object with additional rows and columns with key All or ExtendedKey[…,All], containing aggregated information about groups of rows and columns.
Examples
open all close allBasic Examples (1)
Scope (1)
Make a pivot table showing the percent survival for the Titanic:
By default, PivotTable does not add group summaries:
Show group summaries, with a row and a column of key All:
Applications (1)
The data contains information on kidney transplant patients—time in days to death or on-study time since transplant at the given age:
Use the PivotTable to compute the patients' mean survival time in years split according to alive status versus gender and race, including the summary groups:
Text
Wolfram Research (2025), IncludeGroupAggregates, Wolfram Language function, https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html.
CMS
Wolfram Language. 2025. "IncludeGroupAggregates." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html.
APA
Wolfram Language. (2025). IncludeGroupAggregates. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/IncludeGroupAggregates.html