Pivot tables-multiple payments

M

Marnie

How can I set up a list with a list of payees and payments due in different
months? The end result is that I want to be able to create a pivot table
where I can see how much is due in what month.
 
D

Debra Dalgleish

You can enter the data in a table, e.g.:

Payee Date Amt Transaction
Ann 1/1/2005 63 Due
Dan 1/3/2005 45 Paid

Then, create a pivot table with date in the row field, transaction in
the column area, and amount in the data area.

Group the dates by month, and you'll get the total due and total paid
per month. There's information here on grouping:

http://www.contextures.com/xlPivot07.html

There are instructions for pivot tables in Excel's Help, and Jon Peltier
has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 
Top