Dear Freinds,
I have spreadsheet that keeps track of invoices, paid, unpaid, and over paid. I want to count the number of UNPAID invoices and the their outstanding values in a given month. After I calculate the amount, i want to pull the values to the pivot. I have tried putting the balance column twice when creating the pivot but have been unsuccesful in getting the correct values.
Any help is greatly appreciated. i have uploaded excel file
thanks in advance
rushdhi
Bookmarks