LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Customize Filter List in Pivot Tables

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#REF in Sheets that refer to Pivot Tables Will C. Excel Discussion (Misc queries) 1 June 2nd 06 08:54 PM
Pivot Table Sort & Top List excel_user123456 Excel Discussion (Misc queries) 0 June 23rd 05 08:53 PM
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222 Excel Worksheet Functions 0 February 22nd 05 04:55 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"