Excel 2007 - how to do PivotTable on filtered, visible data only?

Z

ZMAN

Is there anyway to run a Pivot on filtered data only so that the
outcome will not use the entire spreadsheet to calculate the table but
only the visible data that is filtered?
 
Top