Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging - show net due in oldest age category
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 -- Julie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Oldest Date | Excel Discussion (Misc queries) | |||
oldest date not completed | Excel Worksheet Functions | |||
oldest incomplete job | Excel Worksheet Functions | |||
Accounting Category Display does not show the correct format/outpu | New Users to Excel | |||
TEN OLDEST DATES | Excel Worksheet Functions |