Order column in pivot table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to force the order of the column headings in a pivot table of multiple selections
The heading i have are like 200402, 200403 etc. Each month I have a new column and its not sorting. i.e 200403, 200402, 200404 etc

Any ideas appreciated

John
 
Try rightclicking on the column heading (in the pivottable).
Select Field Settings
Click on Advanced
And choose your sort order there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

howto select distinct values from list 6
help with query 1
Help with a date SQL query 1
Unable to Group in Pivot Table 1
Q: Can't get crosstab query to work right 5
Retaining the order of Data while using Pivot table 9
how to create suffix for auto increment 16
How I can set dynamic pivot table ONLY when I have enough data point 1

Back
Top