Drop-down list for report filter in Pivot Table

[JackDanIce]

Hi,

I have a pivot table for say department, manager and clients.

Department is the report filter, then the table shows which clients below to which manager. Currently for the department, I have to explicitly choose the department from the available fields but I want to change this to be a drop-down list of all available departments. My pivot table currently looks like:

	A	B	C
1	Private Clients	(All)
2
3	Manger Name	Client Name	Sales
4	Andy	Client1	1
5		Client2	2
6		Client3	3
7	Billy	Client4	4
8		Client5	5
9		Client6	6
10		Client7	7
11	Grand Total		28

<colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 98px"><col style="WIDTH: 84px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

The first box coloured purple (cell A1) is manually selected as the Report Filter, Manager Name is a row label as are Client Name and Sales. If possible, how do I change A1 to be a drop-down list of all available departments (e.g. departments might be Private Client, Residential, Institutional, etc)? I realise I need to state somewhere what these values are but I don't know how to go about doing this - any ideas?

Thanks in advance,
Jack