Cascading page filters ona pivot table/ pivot chart

[obiron]

Hi all,

Using Excel 2003 on XP via Ctirix....

Thanks to all the help I have received on this board, I have now sucessfully managed to extract 250,000 records from a calculations sheet into 4 worksheets and amalgamate these sheets into a single pivot table.

In this table I have three fields in the paging section: Department, Style and SKU.

A Style belongs to a department and a SKU belongs to a style. Is it possible through VBA to limit the records seen in the style and SKU drop downs to only those elements that belong to selected parent records.

E.G.

Dept Style SKU
1... A123. A12308
1... A123. A12310
1... A123. A12312
1... B456. B45608
1... B456. B45610
2... C555. C55508
2... C555. C55510

IF I select Dept 2 in the department page drop down, I currently see styles A213,A546, B546 and C555 in the Style drop down. I would like to only see C555 as this is the only style associated with Dept 2.
I would also only like to see C55508 and C55510 because these are the only SKUs associated with the currently selected style (C555)


TIA

Obiron