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?