Formula hub · Updated May 13, 2026

Pivot Tables

Build useful pivot tables, refresh reports, group values, and troubleshoot odd totals.

Guides in this category

Pivot Table Basics

Build a simple pivot table to summarize rows by category, status, date, or owner.

Pivot Table Group Dates by Month

Group dates by month, quarter, or year in an Excel or Google Sheets pivot table.

Pivot Table Shows Count Instead of Sum

Fix a pivot table value field that counts records instead of summing numbers.

Pivot Table Not Refreshing

Fix pivot tables that do not show new rows, changed values, or updated source data.

Pivot Table Field List Missing

Bring back a missing pivot table field list in Excel or Google Sheets.

Pivot Table Grand Total Wrong

Fix pivot table grand totals that look wrong because of filters, source data, value settings, or calculated fields.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.