Rearrange data columns in Pivot Table

[hedrew3]

In a pivot table, how do you rearrange the column order in the data
section?
Right now I show columns named A, B, C, and Grand Total.
I want to be able to rearrange them as follows (for example):
Grand Total, B, A, C.

I am using Excel 2000.

TIA

 

[JulieD]

Hi

i'm not sure if you can move the "grand total" column, but the others can be
easily re-arranged by just typing the names in the order you want (ensure
that you don't make any typing errors though), what i mean is,
click on the A heading and type B
once you press enter B will now come first and A will be moved
continue as required.


Hope this helps
Cheers
JulieD

 

[hedrew3]

Hi

i'm not sure if you can move the "grand total" column, but the others can be
easily re-arranged by just typing the names in the order you want (ensure
that you don't make any typing errors though), what i mean is,
click on the A heading and type B
once you press enter B will now come first and A will be moved
continue as required.

Julie,

I tried to type in a new heading in a column but it did not reorder the
columns. Any ideas?

TIA

Pete

 

[JulieD]

Hi

um, always works for me - got to type it EXACTLY and it only rearranges once
you click in another cell or press enter.
but just checking:

you have something along the following lines ...
........A..................B......................C.......................D
3....SumofNums...Department.................
4.....Location........Accounts........Admin................I.T.
5.....North...............57..................67....................3

and you want to see I.T. then Accounts then Admin
so click in B4, type
I.T.
press enter and it should rearrange - as i said i don't think you can move
the grand total.

Let me know how you go

Cheers
JulieD

 

[hedrew3]

Hi

um, always works for me - got to type it EXACTLY and it only rearranges once
you click in another cell or press enter.
but just checking:

you have something along the following lines ...
........A..................B......................C.......................D
3....SumofNums...Department.................
4.....Location........Accounts........Admin................I.T.
5.....North...............57..................67....................3

and you want to see I.T. then Accounts then Admin
so click in B4, type
I.T.
press enter and it should rearrange - as i said i don't think you can move
the grand total.

Let me know how you go

Cheers
JulieD

Ahhh...the light finally came on. Now it works.

What I kept doing was RENAMING Admin (for ex) to something like 'Human
Resources', and expecting the pivot table to re-sort - which it does
not do.

But now I see what you are saying --- just type in another of the
column (or row) values and it will rearrange the order.

Thanks,

Pete

 

[JulieD]

you're welcome

Ahhh...the light finally came on. Now it works.

What I kept doing was RENAMING Admin (for ex) to something like 'Human
Resources', and expecting the pivot table to re-sort - which it does
not do.

But now I see what you are saying --- just type in another of the
column (or row) values and it will rearrange the order.

Thanks,

Pete