[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59"]Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Account[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Dr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Cr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]01-09-14[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 59, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]40000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]02-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee A[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 81"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]40000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]03-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]35000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]04-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]20000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]05-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Company A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]50000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]06-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]10000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]07-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Company A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]50000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to make the pivot table of this which should auto give the balance. Like this
[TABLE="width: 501"]
<tbody>[TR]
[TD="width: 79"]Account Name[/TD]
[TD="width: 155"][/TD]
[TD="width: 67"] [/TD]
[TD="width: 66"] [/TD]
[TD="width: 76"][/TD]
[TD="width: 58"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Descripton[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Balance[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 501"]
<tbody>[TR]
[TD="class: xl65, width: 79"]Account Name[/TD]
[TD="class: xl65, width: 155"][/TD]
[TD="class: xl65, width: 67"] [/TD]
[TD="class: xl65, width: 66"] [/TD]
[TD="class: xl65, width: 76"] [/TD]
[TD="class: xl65, width: 58"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 234"]
<tbody>[TR]
[TD]Account[/TD]
[TD](All)
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]01-09-14
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[/TR]
[TR]
[TD]02-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]40000[/TD]
[TD][/TD]
[TD]-40000[/TD]
[TD]-40000[/TD]
[/TR]
[TR]
[TD]03-09-14[/TD]
[TD][TABLE="width: 189"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[/TR]
[TR]
[TD]04-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]20000[/TD]
[TD][/TD]
[TD]-20000[/TD]
[TD]-20000[/TD]
[/TR]
[TR]
[TD]05-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[/TR]
[TR]
[TD]06-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10000[/TD]
[TD][/TD]
[TD]-10000[/TD]
[TD]-10000[/TD]
[/TR]
[TR]
[TD]07-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50000[/TD]
[TD][/TD]
[TD]-50000[/TD]
[TD]-50000
[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]120000[/TD]
[TD]125000[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]
I Want that it should give Balance like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]01-09-14
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[/TR]
[TR]
[TD]02-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]40000[/TD]
[TD][/TD]
[TD]-40000[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]03-09-14[/TD]
[TD][TABLE="width: 189"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[/TR]
[TR]
[TD]04-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]20000[/TD]
[TD][/TD]
[TD]-20000[/TD]
[TD]15000[/TD]
[/TR]
[TR]
[TD]05-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[TD]65000[/TD]
[/TR]
[TR]
[TD]06-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10000[/TD]
[TD][/TD]
[TD]-10000[/TD]
[TD]55000[/TD]
[/TR]
[TR]
[TD]07-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50000[/TD]
[TD][/TD]
[TD]-50000[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]120000[/TD]
[TD]125000[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59"]Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Account[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Dr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Cr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]01-09-14[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 59, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]40000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]02-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee A[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 81"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]40000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]03-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]35000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]04-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]20000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]05-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Company A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]50000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]06-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Employee B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]10000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD="class: xl65, width: 59, align: right"]07-09-14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Company A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="class: xl65, width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]50000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to make the pivot table of this which should auto give the balance. Like this
[TABLE="width: 501"]
<tbody>[TR]
[TD="width: 79"]Account Name[/TD]
[TD="width: 155"][/TD]
[TD="width: 67"] [/TD]
[TD="width: 66"] [/TD]
[TD="width: 76"][/TD]
[TD="width: 58"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Descripton[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Balance[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 501"]
<tbody>[TR]
[TD="class: xl65, width: 79"]Account Name[/TD]
[TD="class: xl65, width: 155"][/TD]
[TD="class: xl65, width: 67"] [/TD]
[TD="class: xl65, width: 66"] [/TD]
[TD="class: xl65, width: 76"] [/TD]
[TD="class: xl65, width: 58"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 234"]
<tbody>[TR]
[TD]Account[/TD]
[TD](All)
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]01-09-14
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[/TR]
[TR]
[TD]02-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]40000[/TD]
[TD][/TD]
[TD]-40000[/TD]
[TD]-40000[/TD]
[/TR]
[TR]
[TD]03-09-14[/TD]
[TD][TABLE="width: 189"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[/TR]
[TR]
[TD]04-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]20000[/TD]
[TD][/TD]
[TD]-20000[/TD]
[TD]-20000[/TD]
[/TR]
[TR]
[TD]05-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[/TR]
[TR]
[TD]06-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10000[/TD]
[TD][/TD]
[TD]-10000[/TD]
[TD]-10000[/TD]
[/TR]
[TR]
[TD]07-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50000[/TD]
[TD][/TD]
[TD]-50000[/TD]
[TD]-50000
[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]120000[/TD]
[TD]125000[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]
I Want that it should give Balance like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Dr[/TD]
[TD]Cr[/TD]
[TD]Difference[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]01-09-14
[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[TD]40000[/TD]
[/TR]
[TR]
[TD]02-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]40000[/TD]
[TD][/TD]
[TD]-40000[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]03-09-14[/TD]
[TD][TABLE="width: 189"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Salary payable[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[TD]35000[/TD]
[/TR]
[TR]
[TD]04-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]cheque paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]20000[/TD]
[TD][/TD]
[TD]-20000[/TD]
[TD]15000[/TD]
[/TR]
[TR]
[TD]05-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]raw material purchased[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]50000[/TD]
[TD]50000[/TD]
[TD]65000[/TD]
[/TR]
[TR]
[TD]06-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD]Cash paid for salary[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10000[/TD]
[TD][/TD]
[TD]-10000[/TD]
[TD]55000[/TD]
[/TR]
[TR]
[TD]07-09-14[/TD]
[TD][TABLE="width: 189"]
<tbody>[TR]
[TD="width: 189"]cheque paid for raw material[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50000[/TD]
[TD][/TD]
[TD]-50000[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]120000[/TD]
[TD]125000[/TD]
[TD]5000[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]
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.