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!
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!