Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
For you pivot table experts, I have five pivot table field categories: IO, CC, CC Mgr, RC, and DAC - all within one pivot table. I would like to group (or sort) IOs (the first-order row category), by the items in the DAC row field (fifth-order row category). There isn't such a feature in Excel 2003 to group (sort) a first-order row field according to a subsequent-order field, is there? Assuming that there isn't, I would need to use VBA to do this grouping. I would also like to do another grouping (or sorting) of IOs (the first-order row category) by the RC (the fourth-order row category). Therefore, I would need more code to this secondary grouping. Any help would be immensely appreciated! Many thanks in advance, -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.948-9557 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
grouping dates in pivot table: calculated field? | Excel Worksheet Functions | |||
grouping using a automated day field in a pivot table | Excel Worksheet Functions | |||
Grouping a data field in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Grouping or Calculated Field | Excel Discussion (Misc queries) | |||
grouping field in pivot table! | Excel Worksheet Functions |