In conclusion, creating a consolidated PivotTable in Excel using data from multiple sources is a powerful way to analyze and visualize complex datasets.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.