Is it possible to use Autofiltered data as the source for a Pivot Table?
Here’s the data layout. Columns for: Class, Date, AccumulatedHours, RepairCosts. The data has Autofilter applied so I can view all the records of a particular Class and with AccumulatedHours less than a specified amount.
I have added a SUBTOTAL function so that I can see the Sum of RepairCosts for the currently-displayed records. The SUBTOTAL function repects the current Autofilter, and operates only on the displayed records (in contrast to the SUM function).
What I would like to do is make a Pivot Table that also respects the current Autofilter, however, I haven’t seen a way to do that. In other words, I would like to Pivot only on data where AccumulatedHours < xxxx. The only alternative I can think of is to copy all the filtered records to a temporary location and build the Pivot Table on the copied data.
Is there a way to combine the Autofilter with the PivotTable?
Thx.
