Linking pivot table filters

[nooders]

Good afternoon!

I've been banging my head against this problem for a while now, so any help offered would be hugely appreciated!

I'm trying to write a macro that links pivot table filters - i.e. if one 'master' filter changes, all other similar filters change with it.

To do this, I've been trying to input the selection of the master filter into the slave filters, but with no luck. I guess my question is this - is there a special way of referring to the filter fields in vba?

Many thanks.

 

[SkipVought]

Hi,

I know of no way of 'linking' filters.

However, I do this often using MS Query with drill-down combo boxes -- same concept.

Use the selection, be it a combo box or a pivot field filter, to drive a query based on that selection. As the drill-down proceeds, each query requires an additional where clause criteria.

The problem with the PT selection is that there is no way that I know of to get the filtered resultset into the next pivot field, except, perhaps, to clear all pivot item values other than the values returned from the query. But it would be real klunky.

I would definitely opt for a series of queries with combo boxes without the Pivot Table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}