Ok..
But you can play around by creating an additional column on the right side, see the attachment. Thanks.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
Regards,
DILIPandey
<click on below 'star' if this helps>
Bookmarks