In this case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Click the downward triangle icon next to Row Labels. In the filtering pop-up that appears, select Products 1, 2, and 3. The PivotTable will change to show only those three products.