Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering by criteria within Pivot Tables in Excel 2000
I am using Excel 2000 to create a cross-tabulation using Pivot Tables. The
problem I am have is that some fields have 4 letter codes and I need to filter/manipulate rows by permutations of the 4 letter codes. For example CASE CODE <------ Field Name ADER ADRT ADRS AWRU What need is the ability to filter/select the pivot tables' rows by criteria such as "AD*", or "ADRS AND AWRU." The final pivot table would be structured like this ORDERED BYREGION, then Type Cat 1: count(ADER, ADRS, ADRT) Cat 2: count(ADRS + AWRU) Cat 3: count(AWRU) I think this MIGHT be possible in Excel 2007 - might it be possible in Excel 2000? Thanks for your help on this one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering in pivot tables | Excel Discussion (Misc queries) | |||
Sorting in Excel 2000 Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
Filtering within Pivot Tables | Excel Discussion (Misc queries) | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) |