So the 3-character 'state' is in fact the 3-letter abbreviation for a month?
I haven't found anywhere how to change that to a full month spelling, so a work-around is needed. There are two ways I can suggest:
1. In the report select the cell with the 3-letter abbreviation for the month and overtype/edit it to read the full month name, so you see Jan, edit it to read January. You will need to do it for the 12 months but that's all. All other instances of Jan in the pivot will also change to January, regardless of which year, and it will stay that way for that pivot table. I have done this for Jan/Feb/Mar in your Supplies report.
(You can do this for all row and column headers in a pivot, so, for example, you could change Sum of Total Price to something else, say Price.)
If you only have a small number of pivot tables you need to do this with it's probably the way to go, but if you have loads of pivot tables that you'll want to create from that same source data, it would then be worth doing it the second way:
2. Add a column to your source data which shows the month in full. Then refresh the pivot to make the new month field visible in the pivot table's field list on the right, then substitute the current Months (Date) with the new Month field.
I have done this on a copy of your pivot at cell E2 of the Supplies Report sheet.
When adding to the source data, the new Month column there will automatically be calculated for the new data.
|