English

#pivot-table

10 tutorials tagged “pivot-table”.

Excel How-to

Cannot Group Dates in an Excel Pivot Table

Fix “Cannot group that selection” when you try to group dates in an Excel pivot table. Check for dates stored as text, mixed types, and how to convert them so months and years group.

3 min read
Excel How-to

Excel Pivot Table Shows Count Instead of Sum

Fix a pivot table that counts rows instead of adding revenue. Why Excel and Sheets default to Count when a column has text or blanks, and how to switch Values to Sum.

3 min read
Excel How-to

How to Add a Calculated Field in an Excel Pivot Table

Add a calculated field to an Excel pivot table, such as a 10% commission on revenue. Where the dialog lives, how the formula is written, and when a helper column is better.

3 min read
Excel How-to

How to Change a Pivot Table Data Source in Excel

Point an Excel pivot table at a new or wider range, or at a table, so new rows are included. Different from a refresh that only reloads the existing source.

2 min read
Excel How-to

How to Create a Pivot Table in Excel (Step by Step)

Build a pivot table in Excel from a sales list, switch Count to Sum, and refresh when rows are added. Includes tested SUMIFS cross-checks and GETPIVOTDATA formulas that also work in Google Sheets.

7 min read
Excel How-to

How to Make a Chart in Excel (Column, Line, Pie)

Make a column, line, or pie chart in Excel from a clean summary range. Includes a tested monthly sales table, what to leave out of the data, and the Google Sheets menu names.

6 min read
Excel How-to

How to Remove Blanks from an Excel Pivot Table

Get rid of a (blank) row or column in an Excel or Google Sheets pivot table by fixing empty source cells, filtering the item out, or tightening the source range.

3 min read
Excel How-to

Running Total in an Excel Pivot Table

Show a running total in an Excel or Google Sheets pivot table with Show Values As, and check it against a cumulative SUM of the same months or categories.

2 min read