Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Is it possible to use some kind of formulas to filter Pivot tables, like with the Auto-filter functionality ? For example, I have a pivot table showing me Customer information, but my customer codes start with a letter, then a numbering. Axxxx, Bxxx etc... Can I filter on this field for 'all customers starting with A ?' without having to tick/untick all records I want to see ? Or, on a date field, all dates between say 01/01/2005 and 15/09/2005 ? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | 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) |