JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
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:
<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
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