Filtering Grand Total Amounts Within Excel Pivot Tables

Spreadsheets and graphs on a desk
xfgiro/istock

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.

Replies

Please login or register to join the discussion.

avatar
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)
avatar
Jun 16th 2017 17:56

As an Auditor this article would help me a lot in performing data analysis and to focus on risk audit areas.

Thanks (0)
avatar
Jul 23rd 2017 06:15

Filtering Grand Total Amounts Within Excel Pivot Tables Article helps me from risk.Thanks you so much to admin for sharing this valuable post with us and i am sure http://www.lyricslay.com/ will also helps many others.

Thanks (0)