How To Filter Grand Total In Pivot Table

Anyone who has worked with pivot tables has likely found information technology easy to filter rows or columns within the pin table, and every bit yous'll meet in this commodity, you tin can indeed filter any element of a pin tabular array that you wish.

When you click the arrow within the Row Characterizations or Column Labels sections, a drib-down carte du jour lets y'all cull what you'd like to run into. At beginning glance, it may appear that you cannot filter the Grand Total column or row inside a pivot table.

To build a pivot table in Excel you must kickoff with a list, equally shown in Figure i. Make sure that yous take a unique title at the superlative of each column, and that the title is comprised of a single row. As shown in Effigy 2:

1. Click any cell within the list.
2. Activate the Insert menu.
3. Cull the Pin Tabular array command.
4. Click OK.
5. When the new pivot tabular array appears, click any text-based field to add information technology to the Rows department, such equally Vendor.
6. Drag any text-based field to the Columns section, such as Product.
7. Click corporeality-based field to add it to the Values section.

Effigy ane: Ideal data for a pin table is in a list form such as this.

Figure ii: Transforming a list into a pivot table report only requires a handful of mouse clicks.

You're at present ready to see how to filter information within the pin table. For example, permit'southward say that we wish to only see sales of apples and oranges, every bit shown in Figure 3.

1. Click the arrow in the Column Labels field.
2. Uncheck the checkboxes for all items except Apples and Oranges.
3. Click OK.
4. The pivot tabular array only displays columns for Apples and Oranges.

Figure 3: The pivot table allows you lot to filter for specific columns.

You can filter rows in a similar fashion, as shown in Figure 4:

1. Click the arrow in the Row Labels field.
2. Type the discussion Fruit in the Search Box (or manually filter in Excel 2007 and before).
3. Click OK.
4. The pivot table at present only has rows for vendors that take the word Fruit in their proper name.

Effigy 4: The pivot tabular array allows you to filter for specific columns.

As shown in Figure 5, nosotros can reset the pivot table to show all the information again:

1. Activate the Analyze menu in Excel 2013 or after, or the Options menu in Excel 2010 and earlier. This bill of fare is only bachelor when your cursor is within the pivot tabular array.
2. Choose the Clear control.
3. Choose Articulate Filters.
4. The pin table at present shows all the data.

Effigy v: Reset the pivot table to view all the data again.

Now that you're grounded on filtering within a pivot table, let's now filter the grand totals, as shown in Figure half-dozen:

1. Assuming you lot wish to filter the Grand Total column, click the arrow in the Row Labels field.
2. Choose Value Filters.
3. Select an choice from the submenu, such equally Greater Than.
4. Enter an amount, such as 300000.
5. Click OK.
6. The pivot table is filtered to prove only grand full amounts greater than 300,000.

Figure six: You can also filter the pin table by the Grand Total column.

Filtering the Grand Total row works in the aforementioned fashion, except yous'll utilize the Value Filters command from the menu in the Column Labels field.

How To Filter Grand Total In Pivot Table,

Source: https://www.accountingweb.com/technology/excel/filtering-grand-total-amounts-within-excel-pivot-tables

Posted by: vinsonpaun1939.blogspot.com

Share this post