This will remove the Subtotals for Store#1 and Store#2 and the Pivot Table will only indicate the Grand Total of items sold by both the stores. If the option is grayed out—not available—in Excel 2003, then it could be because the data table has been defined as a list. You can then use the new field with the A & B values as your first dimension and use subtotals on … I know how to subtotal the data (w/o it being in a pivot table) but that will put the sum and the count on separate lines. By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. Otherwise, it might be a one-time glitch. Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. Add Subtotals in Pivot Table. To quickly display or hide the current subtotal, right-click the item of the field, and then select or clear the check box next to Subtotal "