Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the value of a filter field in a Pivot Table?
Hi all,
I have a set of reports connected by ODBC ... bla. and with 4 settings (month, organization, report type and role) the reports automatically fulfills everything. Now I need to automatically use 1 of these values (month) that is inputed in the first worksheet and to filter the Pivot Table by the selected month (the field that you put above) How can I (by reference or even by VBA) set the filter with the required value? If you want to see the Pivot Table for a certain month, you must to manually set the required month, I Have in 1 of the excels about 12 Pivot tables and I don't want to force the user to change the month in each one of them - how can I please automate it? do you have any experience with this? Thank you. Iglesias. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form to change manual field filter in pivot table | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table Field | Excel Worksheet Functions | |||
The Pivot Table field name is not valid, | Excel Discussion (Misc queries) | |||
The Pivot Table field name is not valid, | Excel Discussion (Misc queries) |