How to display multiple grand total rows in a Microsoft Excel PivotTable
Image: wachiwit/Adobe Stock
Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and they display information in…
Browsing Tag
PivotTable
How to return the first and last times from timestamps in a Microsoft Excel PivotTable
When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.
Image: Diego/Adobe Stock
The article How to…
How to show details in a grouped PivotTable in Microsoft Excel
It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.
Image: wachiwit/Adobe Stock…
How to display multiple subtotal rows in a Microsoft Excel PivotTable
Use this hard-to-find setting to display multiple subtotals in your Microsoft Excel PivotTables.
Image: sdx15/Adobe Stock
Microsoft…
How to add conditional formatting a Microsoft Excel PivotTable without expressions
You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.
Image: Diego/Adobe Stock…
How to calculate a conditional running total using a PivotTable in Excel
At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins…
How to return the top or bottom n records without a filter or PivotTable in Excel
There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so…