Hi All,

I've created a PivotTable which is pulling data from a SQL Database.

I need some help with the Report Filters. At the minute I have 4 filters

Basically, 3 of the filters (the first is Date) are dependant on the results of the previous filter...

i.e. Line Manager 1 has Team Manager A, B and C. Line Manager 2 has Team Manager D, E and F.

Currently, if I select an option in the first filter; the second report filter still has all options, instead of just those that apply to the previous filter.

Is this possible with PivotTables? I've created a solution using ComboBoxes and VB code but I do not like the limitation of not having multiple-select with comboboxes (and I don't want to use listboxes)

Thanks