View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HeatherJ HeatherJ is offline
external usenet poster
 
Posts: 24
Default Filtering within Pivot Table

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