(repostX2) Pivot table: Grouping first row field by fifth row fiel

[Guest]

Hi,

For you pivot table experts, I have five pivot table row-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,

 

[Guest]

I could do the re-ordering manually, but as soon as I refresh the data
underpinning the pivot tables, any new internal orders would not be
placed in the proper sequence since Excel isn't intelligent enough to keep the
ordering system intact....

 

[Guest]

How about using the pivot table values as a source in a formula placed in
another fixed table? At this point, I could use Excel's adequat sorting
function to sort/goup any way I wish to subsequent to the refresh of data
from the pt. I would also have much more flexibility in formatting the
table... but this would entail
much more templating work, etc.

What are people's thoughts on this pivot table reverse-grouping dilemma?

 

[Guest]

Peter suggested that I use a "dictionary object" for ordering the row fields
(with the attendant data of course) and printing them at the bottom of the
pt, but I don't quite know how to accomplish this....