How to change column sequence in pivote table for pivoted dimension??

[soha1902]

Hi All,

I am using one pivot Table. for ex:

Emp	Dept	Over time	Total Leave	Working Hour	Sal

Now I want to change the order of column. Like I want Total Leave in 6th column , Sal in 5th column and Working hour in 4th column in chart level not script level.

How can I do this???

Please help....Thanks in Advance

Note:Over time, Total leave,Working Hour and Sal belongs to Single Dimension only and I am Pivoting That Dimension. So Promote Demote Optin is not available.

[alexandros17]

Click on the column header and drag it where you want ...

[soha1902]

Drag and drop is not working for pivoted dimension.