I have a pivot table with all my accouts transactions. I am trying create a month by month balance sheet.
I can get the running total to work month 1 (ie March 2011) onwards but I need it to pick up the opening balance which sits at >01/03/2011.
Can anybody help?
I can get the running total to work month 1 (ie March 2011) onwards but I need it to pick up the opening balance which sits at >01/03/2011.
Can anybody help?
