• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Confused Ledgor Balance in Pivot

I

inbp

Member
Hi Dears Excel Greats


I want to get ledger in excel using pivot.


i have a sheet in which i am entering advances (Dr.) and their adjustment (Cr.)


Format is


Date Name Description Debit Credit


in pivot i am using slicer of name that i can get the balance (due amount)of a person


in pivot i need the following detail and name is using as filter via slicer


Date Description Debit Credit Balance


balance column is need to be added in pivot


formula will be f3+D4-E4


i use calculated field, but it isn't work.


Below is the file


http://www.2shared.com/file/HsxNhnCr/Advances_Ledger_in_Pivot.html


I shall be grateful for your assistance


Regards,


Muhammad Shakeel
 
You are working excel 2010??? I am working in Excel 2007 and cann't find any thing in F Column..


Faseeh
 
Good day Faseeh


You truly deserve to be a ninja

A question is posted and you sort it out with out posting an answer, absolutely first class :)
 
You must log in or register to reply here.
Back
Top