I am relatively new to pivot tables, but I think one would be helpful in to show cashflow over time. Ideally I could easily change the frequency between daily, weekly, monthly, quarterly, and annually. I have attached a spreadsheet with a sample table of transactions to be accounted for in the cash flow, along with an example of what I want (not using a pivot table). My problem is having the pivot table calculate beginning and ending cash balance, and adding in balance adjustments (I need this so I can update the actual cash balance we have in the bank).
Also, could PowerPivot be helpful with this?
I hope my phrasing of the question isn't too confusing!
Thanks for your help!!
Bookmarks