To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Susan Harkins previously taught us how to display subtotals in PivotTable, and now she shows you how to build and use grand total rows.

Fortunately, I can offer two alternative methods that I think will meet your needs by using Excel’s Subtotal or PivotTable tools, as follows. Subtotal approach. To summarize and group your weekly ...