Aging - show net due in oldest age category

[Julie]

I have a pivot table that summarizes Accounts Receivable figures as they
appear in aging type time buckets. This is not really aging it just shows
how old each charge or credit is. I'm trying to make it into a true aging by
showing the net receivable for each control in the oldest time bucket. In
the example below, I want to report 2384.17 as an over 120 Day Receivable,
and the 150 lower down as an over 90 day receivable. The individual nmbers
that add up to the net due do not need to be reported, just the net due in
the proper bucket.

Can someone please tell me how to do this?


Control Current Over 30 Over 60 Over 90 Over120 Net Due
419703 -2885.28 5269.45 2384.17
420794 -125 -125
421162 1099 1099
421594 495.21 495.21
422521 -2141.47 2291.47 150
422903 781.38 781.38
423200 6524.82 6524.82
423423 1470 1470
423830 -1709.47 1859.47 150
423998 824.7 824.7
424036 423.74 -1357.98 -934.24
424545 7798.1 7798.1
424850 -1544 2900.01 1356.01
425000 738.41 738.41
425397 159.28 159.28
425447 -8455.64 10380.69 1925.05
425470 87.28 87.28
425487 4815.04 4815.04
425524 2027.99 2027.99
425602 2749.88 2749.88
425670 -1966.85 3216.86 1250.01
425716 -100.15 -100.15