Filtering Grand Total Amounts Within Excel Pivot Tables

Spreadsheets and graphs on a desk

Anyone who has worked with pivot tables has likely found it easy to filter rows or columns within the pivot table, and as you’ll see in this article, you can indeed filter any element of a pivot table that you wish.

When you click the arrow within the Row Labels or Column Labels sections, a drop-down menu lets you choose what you’d like to see. At first glance, it may appear that you cannot filter the Grand Total column or row within a pivot table.

To build a pivot table in Excel you must start with a list, as shown in Figure 1. Make sure that you have a unique title at the top of each column, and that the title is comprised of a single row. As shown in Figure 2:

  1. Click any cell within the list.
  2. Activate the Insert menu.
  3. Choose the Pivot Table command.
  4. Click OK.
  5. When the new pivot table appears, click any text-based field to add it to the Rows section, such as Vendor.
  6. Drag any text-based field to the Columns section, such as Product.
  7. Click amount-based field to add it to the Values section.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

Jun 7th 2017 18:42

David - another excellent article. You're one of my favorites for putting Excel to use in helping me help my clients get actionable insights from their data.

Chris Hunter
Cornerstone Business Solutions
Farmington, NM

Thanks (0)