G
Guest
Hi,
For you pivot table experts (and project managers), I have five pivot table
row-field categories: IO (Internal Order), CC (Cost Centre), CC Mgr, RC
(Responsibility Centre), and DAC (District Assistant Commissioner's Office) -
all within one pivot table. I would like to group (order) my data starting
with the items in the DAC row field (fifth-order row category) and then group
(order) items in the RC row field (fourth-order row category) within the DAC
categories.
Assuming that there isn't such a tool, I would need to use VBA to do this
grouping (or ordering if you prefer).
Conventionally, the smallest child field should be at the end of row fields
with the largest grouping at the beginning. This would make
sorting/ordering/grouping easy. However, my client has a project-matrix
organization with projects crossing many divisions. Therefore, the smallest
grouping (i.e. the Internal order - IO) is the driver of the data and resides
at the beginning of the row fields with the largest grouping (the District
Assistant Commissioner's office - DAC) residing at the end of my row fields.
I believe that I need VBA code to do the ordering since this ordering is
starting at the end of my row fields and not at the beginning...
Please help
Many thanks in advance,
For you pivot table experts (and project managers), I have five pivot table
row-field categories: IO (Internal Order), CC (Cost Centre), CC Mgr, RC
(Responsibility Centre), and DAC (District Assistant Commissioner's Office) -
all within one pivot table. I would like to group (order) my data starting
with the items in the DAC row field (fifth-order row category) and then group
(order) items in the RC row field (fourth-order row category) within the DAC
categories.
Assuming that there isn't such a tool, I would need to use VBA to do this
grouping (or ordering if you prefer).
Conventionally, the smallest child field should be at the end of row fields
with the largest grouping at the beginning. This would make
sorting/ordering/grouping easy. However, my client has a project-matrix
organization with projects crossing many divisions. Therefore, the smallest
grouping (i.e. the Internal order - IO) is the driver of the data and resides
at the beginning of the row fields with the largest grouping (the District
Assistant Commissioner's office - DAC) residing at the end of my row fields.
I believe that I need VBA code to do the ordering since this ordering is
starting at the end of my row fields and not at the beginning...
Please help
Many thanks in advance,