Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an excel workbook containing several pivot tables based off the
same data. On some of the pivot tables, I would like to specify exactly the fields that come up under a specific filter. Can this be done? For example, I have a category column in my data. In that column I am using a filter to restrict the choices to the following choices: Invoiced Expenses Actual Expense Actual Worked Budget Expenses Budget Labor CTO Hours / Job Summary Invoiced Labor Unbillable Expenses Unbillable Labor In one of my pivot tables, under the category filter, I would only like 'Invoiced Expenses' and 'Invoiced Labor' to show up as the options to select. How can this be done? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Table Sort & Top List | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |