Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab Aging (2003)

    I'm trying to get an aging of my data and figure a crosstab is the best way, but I'm unfamiliar with them and how to make it work.

    My data has a BU, a $$, and a date.

    I need something that looks like the attached.

    How would I go about doing so?

    Thanks!
    Attached Files Attached Files
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Crosstab Aging (2003)

    You could add a column to the original data that calculates the difference between TODAY() and the date column. (Excel tends to format such a difference as a date, simply clear the formatting to see the difference as a number of days).
    Next, add a column to compute the age groups, with a formula such as
    =IF(D2<60,0,IF(D2<=120,60,IF(D2<=365,121,IF(D2<=73 0,366,731))))
    You should now be able to create the pivot table.
    If you need more help, please provide a small sample of the source data.

Posting Permissions

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