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
Bookmarks