Adjust Pivot column order?

edited January 23 in Technical questions

I have a pivot table for which I am displaying columns by Year then by Month. Unfortunately, the month columns are not appearing in a naturally sorted order. They seem to be appearing in the order they appear within the data.

Is there a way to force the columns to appear in numerical order? Or, do I need to pre-sort the data by Year, then Month?

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!