How about using the pivot table values as a source in a formula placed in
another fixed table. At this point, I can use Excel's sort function to sort
any way I wish 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?
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557


" wrote:

On Jul 11, 1:46 pm, klysell .(donotspam) wrote:
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!

Is there a reason that IO is your first row field? Do you need to
report grouped on IO or can you reorder your fields to put DAC first,
RC second and the IO (or IO last)

If you need groupings by all 3, you will probably need to write a
macro to do the totaling by RC and DAC. For this type of thing I use
dictionary objects for totalling and then print them out at the end of
the pivot table.

Peter