Excel PivotTables: summarize, filter and refresh

Avoid merged cells and repeated header rows in the source data. [1][2]

An Excel Table can expand as new rows are added to the source. [1][2]

Select an existing worksheet range or Excel Table first. [1][2]

Keeps the summary separate from the original data. [1][2]

Ensure the destination area has room for expansion. [1][2]

Produces an aggregate per unique category. [1][2]

Builds a two-dimensional cross-tabulation. [1][2]

Adds a selectable filter over the complete pivot report. [1][2]

Makes City a second level nested within Region. [1][2]

Changes the grouping dimensions without modifying source records. [1][2]

Removes a field from the report without deleting the source column. [1][2]

Reopen the field-selection panel when it is hidden. [1][2]

Numeric inputs should be recognized as numbers for a sum. [2][3]

Counts nonempty values of the chosen source field. [2][3]

Shows the arithmetic mean of numeric records. [2][3]

Finds the lowest numeric source value per group. [2][3]

Finds the largest numeric source value per group. [2][3]

Divides each result by the overall report total. [2][3]

Compares a result with the total in its own row. [2][3]

Compares a result with the total in its column. [2][3]

Choose an ordered Base Field to accumulate values across categories. [2][3]

Expresses cumulative amount relative to its selected total. [2][3]

Choose a Base Field and Base Item for comparison. [2][3]

Computes relative difference, provided the baseline is meaningful. [2][3]

Higher numeric values receive better ranks in selected category. [2][3]

The same measure can appear with two interpretations in parallel. [2][3]

Use a descriptive heading such as Total Sales instead of Sum of Amount. [2][3]

Valid Excel dates can be summarized by calendar month. [4][6][2]

Avoid mixing January of different years in one bucket. [4][6][2]

Creates numeric bands for histogram-like summaries. [4][6][2]

Removes manually assigned grouping for the selected field. [4][6][2]

Highlights high-performing groups at the top. [4][6][2]

Restricts which items appear in the report. [4][6][2]

Filters groups based on the computed aggregate. [4][6][2]

Filters displayed category names by text criteria. [4][6][2]

Creates clickable category buttons for filtering. [4][6][2]

Connection requires compatible PivotTables sharing a source. [4][6][2]

Restores all permitted members in the connected report. [4][6][2]

Reveals or hides nested row levels in a hierarchy. [4][6][2]

Displays hierarchical fields in a compact column. [4][6][2]

Gives separate columns to row fields for clearer exports. [4][6][2]

Repeats category labels on each displayed row. [4][6][2]

Reloads and recomputes from the configured source. [5][7][1]

May refresh other connections and PivotTables in the workbook. [5][7][1]

Availability and defaults vary by Excel version and data source. [5][7][1]

Include newly added rows if not using an expanding Table. [5][7][1]

Expanding source Tables make later additions easier to capture. [5][7][1]

An outdated cache or filtered member can hide valid records. [5][7][1]

Blank/text cells can result in Count rather than Sum. [5][7][1]

Text-formatted dates cannot always group as dates. [5][7][1]

Availability varies with connection and field type. [5][7][1]

Grouping treats empty labels as a distinct category. [5][7][1]

A connected visualization follows PivotTable filters and summaries. [5][7][1]

A polished pivot cannot correct incorrect source values. [5][7][1]