Show only pivot field items based on previous pivot field filter

[owentmoore]

Hi all

I know I've seen a response to this question previously but cannot find the FAQ again.

When I select a pivot item for the first pivot field, on viewing the pivot items for the next field, all the pivot items for the previously filtered data are still included.

Why is this? Is there a work around solution?

Thanks
Owen

 

[SkipVought]

Hi,

Yes, that has always bugged me about PivotTables.

Use MS Query, via Data/Get External Data...

Query the table (caveat: one table per sheet) and use the selection (Previous PivotItem) as the criteria to return a DISTINCT list of the Next column.

Skip,

_[red][/red]

 

[owentmoore]

I've had a look at MS Query. Lokos like I'll need to read up on it.

Thanks
Owen