Pivot Table Running balance Problem

[mubasher7]

Date <tbody> </tbody>	Account <tbody> </tbody>	Description <tbody> </tbody>	Dr <tbody> </tbody>	Cr <tbody> </tbody>
01-09-14 <tbody> </tbody>	Employee A <tbody> </tbody>	Salary payable <tbody> </tbody>		40000 <tbody> </tbody>
02-09-14 <tbody> </tbody>	Employee A <tbody> </tbody>	cheque paid for salary <tbody> </tbody>	40000 <tbody> </tbody>
03-09-14 <tbody> </tbody>	Employee B <tbody> </tbody>	Salary payable <tbody> </tbody>		35000 <tbody> </tbody>
04-09-14 <tbody> </tbody>	Employee B <tbody> </tbody>	cheque paid for salary <tbody> </tbody>	20000 <tbody> </tbody>
05-09-14 <tbody> </tbody>	Company A <tbody> </tbody>	raw material purchased <tbody> </tbody>		50000 <tbody> </tbody>
06-09-14 <tbody> </tbody>	Employee B <tbody> </tbody>	Cash paid for salary <tbody> </tbody>	10000 <tbody> </tbody>
07-09-14 <tbody> </tbody>	Company A <tbody> </tbody>	cheque paid for raw material <tbody> </tbody>	50000 <tbody> </tbody>

<tbody>
</tbody>

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

Account Name

<tbody>
</tbody>

Date

Descripton

Dr

Cr

Balance

<tbody>
</tbody>

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.

Account Name

<tbody>
</tbody>

Date

Description

Dr

Cr

Difference

Balance

<tbody>
</tbody>

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.

Account

(All)

<tbody>
</tbody>

<tbody>
</tbody>

Date	Description	Dr	Cr	Difference	Balance
01-09-14	Salary payable <tbody> </tbody>		40000	40000	40000
02-09-14	cheque paid for salary <tbody> </tbody>	40000		-40000	-40000
03-09-14	Salary payable <colgroup><col></colgroup><tbody> </tbody>		35000	35000	35000
04-09-14	cheque paid for salary <tbody> </tbody>	20000		-20000	-20000
05-09-14	raw material purchased <tbody> </tbody>		50000	50000	50000
06-09-14	Cash paid for salary <tbody> </tbody>	10000		-10000	-10000
07-09-14	cheque paid for raw material <tbody> </tbody>	50000		-50000	-50000
Grand Total		120000	125000	5000	5000

<tbody>
</tbody>

I Want that it should give Balance like this.

Date	Description	Dr	Cr	Difference	Balance
01-09-14	Salary payable <tbody> </tbody>		40000	40000	40000
02-09-14	cheque paid for salary <tbody> </tbody>	40000		-40000	0
03-09-14	Salary payable <colgroup><col></colgroup><tbody> </tbody>		35000	35000	35000
04-09-14	cheque paid for salary <tbody> </tbody>	20000		-20000	15000
05-09-14	raw material purchased <tbody> </tbody>		50000	50000	65000
06-09-14	Cash paid for salary <tbody> </tbody>	10000		-10000	55000
07-09-14	cheque paid for raw material <tbody> </tbody>	50000		-50000	5000
Grand Total		120000	125000	5000	5000

<tbody>
</tbody>

But due to Description column Pivot Table does not generate Balance column like this. But when I remove Description column it gives the right balance but I need Description column in my Pivot Table.

​Please help me in this regard.

 

[mubasher7]

And in column F6 it should Balance of 65000 but it is giving 50000.

 

[mubasher7]

Here's the pivot table:

Excel 2010

	H	I	J	K
1	Date	Account	Description	Sum of Balance
2	01/09/2014	Employee A	Salary payable	40000
3	02/09/2014	Employee A	cheque paid for salary	0
4	03/09/2014	Employee B	Salary payable	35000
5	04/09/2014	Employee B	cheque paid for salary	15000
6	05/09/2014	Company A	raw material purchased	50000
7	06/09/2014	Employee B	Cash paid for salary	5000
8	07/09/2014	Company A	cheque paid for raw material	0

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

What results would you expect in column F?

Although thanks for your response. I almost reached the point.