<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<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 |
<tbody> </tbody> | 40000 | 40000 | 40000 | ||
02-09-14 |
<tbody> </tbody> | 40000 | -40000 | -40000 | ||
03-09-14 |
<colgroup><col></colgroup><tbody> </tbody> | 35000 | 35000 | 35000 | ||
04-09-14 |
<tbody> </tbody> | 20000 | -20000 | -20000 | ||
05-09-14 |
<tbody> </tbody> | 50000 | 50000 | 50000 | ||
06-09-14 |
<tbody> </tbody> | 10000 | -10000 | -10000 | ||
07-09-14 |
<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 |
<tbody> </tbody> | 40000 | 40000 | 40000 | ||
02-09-14 |
<tbody> </tbody> | 40000 | -40000 | 0 | ||
03-09-14 |
<colgroup><col></colgroup><tbody> </tbody> | 35000 | 35000 | 35000 | ||
04-09-14 |
<tbody> </tbody> | 20000 | -20000 | 15000 | ||
05-09-14 |
<tbody> </tbody> | 50000 | 50000 | 65000 | ||
06-09-14 |
<tbody> </tbody> | 10000 | -10000 | 55000 | ||
07-09-14 |
<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.