I am trying to use a pivot table to create a general ledger where the Balance Column shows cumulative total. I have tried the running total function, yet it didn't work. I assumed it is because I have too many rows in place? I have attached a sample and would appreciate if anyone can help me with this. Thank you.
This solution is a pseudo column that employees one formula:It also employees two conditional formatting rules:
=IF(H4="","",IF(B4="",SUM(G4-H4,I3),G4-H4))=B4="Grand Total"I have pasted the formula and applied the rules to cells I4:I25 so that you can experiment and see how it works.=AND(B4<>"",B4<>"Grand Total",H4<>"")
Here is a copy of the file attached to post #1 that has the column applied: Pseudo PT Column (formula and CF).xlsx
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc,
It works perfectly. Thanks for the awesome solution and I will play around with the formula.
You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.
Done and thanks for the reminder. May you have a wonderful day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ZeeLee 
Register To Reply
Bookmarks