Pivot Table Filters

[lobop3]

I have a pivot table that includes data using Months of the year in the Column Labels. I was using MONTH(A2) where A2 is an entered date, which returns the numbers 1-12. In my pivot table, I wanted it to say the name of the month. I did a lookup to retrieve the corresponding month name. Simple right! The pivot table does not order the months in chronological order.

For example:
My data is a Dynamic Named Range.
I start with two months of data, Feb and March.
If they go back to add January's data it will put Jan. data after Feb and March.

How can I use one field's data in the pivot table but use a different column label?

 

[lobop3]

I went back and made the month data numbers.
I tried to sort the data by date so the data in the table was in chronological order, and nothing new.

Do the pivot tables cache the data?

 

[namliam]

you can hard sort the columns in piviot tables, but that has the obvious draw back of August being the first month

Only way to enforce the order is to also keep the real number as a row identifier and sort on that....

Failing that, you can keep the month in a REAL date, 01/01/2013 02/01/2013 only using the 1st of each month.... Then simply applly a cell formatting on the cells to show the month name

 

[lobop3]

Thank you for you help!! I didn't realize I could cell format on the pivot table. I ended up doing a couple of things, maybe over kill but it shows up on the pivot table the way I want.

I made my data field a list with only 1/1/13, 2/2/13, 3/3/13 and so on. In the field the user selects the month I used the cell format d-mm so it show as 01-Jan, 02-Feb, 03-Mar. On my pivot table I did the same cell format d-mm on my column header for the date. Then it orders it the way I want!

Thanks!!