+ Reply to Thread
Results 1 to 1 of 1

Help creating an aging report for open credits

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    los angeles
    MS-Off Ver
    Excel 2003
    Posts
    1

    Help creating an aging report for open credits

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. creating an aging report
    By PSikes in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 12:07 PM
  2. creating an aging report
    By azmil in forum Excel General
    Replies: 8
    Last Post: 02-21-2014, 03:45 AM
  3. creating an aging report
    By azmil in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-21-2014, 03:22 AM
  4. [SOLVED] Creating AP Aging Report
    By StingMC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 12:05 AM
  5. Help with Aging Report
    By KimberlyL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2005, 02:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1