Results 1 to 2 of 2
Thread: Crosstab Aging (2003)
2008-12-18, 01:10 #1
- Join Date
- Sep 2001
- Stuck at work..., Missouri, USA
- 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!<font face="Comic Sans MS">Morgan Erickson</font face=comic>
<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.
2008-12-18, 01:33 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 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
You should now be able to create the pivot table.
If you need more help, please provide a small sample of the source data.