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

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 ...

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