Hi petkaml,
See the pivot at sheet1 which has the data from Branch 1, 2 and 3. Hope this helps you to start on. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi petkaml,
See the pivot at sheet1 which has the data from Branch 1, 2 and 3. Hope this helps you to start on. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Hi thank youAttachment 147041Attachment 147041Attachment 147041income statement2.xls
I have to add something
Iťs issue about managing cash flow. When you have enough money you can lend it, otherwise if you don´t you have to borrow.
Problem is that in the pivot table you have to sum up balance for all group.
On sheet 1, row 6 column E in the pivot table is 100 000, but B7 is 25 000, which is initial balance for branch 2, I need to sum it up, so B7 should be 125 000
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks