Question on Pivot Table

[#1]

Hi All!

I have a question regarding pivot table. I have a table that looks like this:

Now the totals : 1000, 140 and 700 (background is red) should be in the Beginning balance value under the Month Feb-2014

So, I have an excel file which contains only the beginning balance for Jan-2014, The total that is generated from Jan-2014 or the Ending balance should be placed on the Beginning Balance of Feb-2014 and so on. (For example, Feb-2014 ending balance will now go to Mar-2014 beginning balance)

How do I achieve this? Is it possible on Pivot table?

Thanks in advance,

Donna

[#2]

bump

[#3]

bump!