Advanced Filters question

[Mike C]

I sometimes use Msft Access to run a query, and then revise the query,
or build off of the new query by creating a separate query of that
query.

However, in using excel, at least at first pass, I noticed that I was
unable to pivot the data that resulted from an advanced filter, and I
was unable to see the total amount for a given column, once an
advanced filter was applied to a list (i.e., the sum that I saw was
for the entire field and not for the records that were visible once I
had applied the filter).

Does anyone have any perspective they could share with me regarding
this? Is there a way to pivot only the filtered data (or do I need to
copy and paste the visible cells into a separate sheet to accomplish
this?

 

[Debra Dalgleish]

A pivot table uses all the records in the data source, not just the
visible data. You could use an advanced filter to extract the data to a
different sheet, or another part of the same sheet. Then, create the
pivot table from the extracted data.

There are instructions here for extracting the data to another worksheet:
http://www.contextures.com/xladvfilter01.html