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?

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

Mike C wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html