The issue contains four fields: IssueID, Month, Year, and Issue. Issue is a formula that combines all three fields to display something like "302 May 2014"

Article references the Issue field so that every article has a "302 May 2014" like field, depending on what issue it belongs in.

When looking at a report of every field of my articles, they all show that format under the "issue" field.

However, when I create a pivot table totaling the cost of each issue, Zoho is splitting the issues in a strange way. For example, if I'm looking at the May issue, half of the data will be shown under "302 May 2014" while the other half is under simply "May 2014." There are no records with "May 2014" in the "issue" field, but the pivot table seems to think that there is.

Some time back, it was just the month and year, but it has been recently updated and looking at the records, there are none that retained the old format. Is it possible the pivot table takes a while to update? It's been about a week.