Aging Report

L

Liz J

I'm trying to perform an aged payable analysis as of 9/30/09. In column A of
my spreadsheet, I have dates (format: 1/1/2009). These dates go from 1/1/2000
to 9/30/2009. In column B, I have invoice dollar amounts.
My goal is to create a pivot table that has columns with the following data:
0-3 months, 3-6 months, then skip to 6-12, 12-18, and 18+ months.

How do I group that in a pivot table?

Thank you for your help!
 
M

Marcelo

use an auxiliar column C for instance for the aged classification and include
it on the Pivot table.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Liz J" escreveu:
 
L

Liz J

There is a good amount of data involved. I think using formulas/ pivot tables
would be the easiest, but I'm not sure of the execution.
 
M

Marcelo

The auxiliar column that I have suggest is to segregate the data on the pivot
table,

you should select the area click on DATA - Pivot Table & Pivot Chart Report
and follow the instrucions.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Liz J" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top