washburncincy
New Member
- Joined
- May 29, 2014
- Messages
- 6
I have a workbook that contains a pivot table. I use this for each of the accounts I handle for my job tracking historical data for the account. I have used this numerous times over the past year+ without incident. Today, though, I was looking at my pivot table and noticed that one of the years (2019) is missing. I've checked my table that is being used as the data source and everything seems to be fine. Here's a shot of what's happening on the pivot table (ignore the 4th column, it's calculated from the 2nd and 3rd):
And here's the corresponding data from the source table:
As you can see, the corresponding values for 2019 are pulling to the pivot table... just not the year. Now, here's an oddity that truly baffles me. In my attempts to "reset" the source data, I copied the value in B37 (2017) and pasted it to B39. Refreshed the pivot table and it aggregated it under the 2017 year row. I thought... oh, it's fixed. But if I replace the 2017 with '2019', it reverts to the problem scenario. This includes if I take the copied '2017', delete the '7' and replace with a '9'. I just don't get it. Thoughts?
And here's the corresponding data from the source table:
As you can see, the corresponding values for 2019 are pulling to the pivot table... just not the year. Now, here's an oddity that truly baffles me. In my attempts to "reset" the source data, I copied the value in B37 (2017) and pasted it to B39. Refreshed the pivot table and it aggregated it under the 2017 year row. I thought... oh, it's fixed. But if I replace the 2017 with '2019', it reverts to the problem scenario. This includes if I take the copied '2017', delete the '7' and replace with a '9'. I just don't get it. Thoughts?