Summary of accounts
I apologize for my inexperience up front but I need some help. I have created a simple file to track revenue and expenditures of several accounts. In a summary report all of the accounts are there with their totals for each category but in the last column I want to show the balance for each account which should be the initial balance + revenue + expenditures but if I do this as a summary field I can't add the fields tougher and if it is a calculation field the total seems to include all accounts not just a specific account.
I am sure there is a way to do this I just don't know how. Thanks for the help.