Pivot Table Running balance Problem

[mubasher7]

Account.xlsx


I want to make the pivot table of this which should auto give the balance. Like this

Date Description Dr Cr Balance

I have used the formulas for this but all in vain.
In this I have first calculated the difference of Cr-Dr, using the Formula option. Then I have calculated the Balance by Running Total of Difference according to Date.

But problem here is while calculating Balance Pivot Table considers the Description and gives the value according to Description. But when the Description column is deleted it gives the right Balance.

Due to Description column Pivot Table does not generate Balance column correct. But when I remove Description column it gives the right balance but I need Description column in my Pivot Table also.

​Please help me in this regard.

[cbatrody]

Hi,

Something like this?