Filtering within Pivot Table

H

HeatherJ

I am filtering in a pivot table. I would like the subtotals to update for
the data I am showing after I have filtered, instead of still counting the
hidden data. Is this possible?

Thanks, Heather
 
K

KC hotmail com>

The pivot table's totals should automatically update correctly if you're
using the pivot table's filtering.

If you're doing your own formula (maybe above the pivot table), then use
=SUBTOTAL(109,B5:B1000) as your formula to sum the range ("9" is to sum)
while ignoring hidden data ("10" in front of the "9" means "ignore hidden
rows"). This is rather redundant, however, because pivot table filters don't
"hide" filtered out data rows...they disappear altogether.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Date Filter Problem 1
Pivot Table Default Setting 1
Are Date filters available for items in the Filter area of pivot t 2
Hide Pivot Table Filters 1
How to list items instead of counting them with Pivot Table 2
Pivot table subtotals 2
Excel Pivot table - need to not remember old data which has been r 3
Problem with Calculated item in Pivot Table 1

Top