reorder pivot table columns

[wanyunyang]

In pivot table I have columns: A, B, C, D, E. They are sorted automatically. I want to reorder them into: C, D, A, B, E, basically just take C&D out. Is there a easier way than doing this in Sort by Expression? Since I have many many columns.

Thank you in advance!

[dplr-rn]

Are all columns you mentioned dimensions?

Pivot table always sorts dimensions in order left to right i believe

[wanyunyang]

Yes all columns are dimension.

[dplr-rn]

Pivot table will be arranged in order that it appears on the screen.  Custom ordering you need to use regular table.

Can you provide a screen shot to expand on the problem

[wanyunyang]

Hi Dilip,

Pivot table supports sort by expression. I'm just wondering if there is a easier way, since I have many columns. If I use sort by expression, I need to type these column names one by one.

[dplr-rn]

I understand that. You can also turn off sorting also.

My point was in pivot if you want custom ordering you  have to use expression