Hi Everyone,
I have been task to create an aging report for open credits my company has outstanding. The credits span from 2010-2014. I've created a pivot table to organize by year, vendor, month. See attach example. My problem is that I can't seem to get the current year2014 to appear, not sure if its a formula problem. Anyways I've attach an example of what I'm talking about. Any help on how to get the pivot table to reflect the current year would be appreciated, or if you have any other suggestion.
Thank You
Bookmarks