Hi,
I´m setting up a variation of your General Ledger Detail report, on Excel, adding some of the available fields and filtering for a specific month.
Is it possible to add a Balance column with the same behavior that I find in QB? i.e., for each account, begin with the balance of the previous month followed by an updated balance in each transaction row?
Thank you
Antonio Mussoi
We don't do anything like that out-of-the box with General Ledger Detail.
In effect you are asking for a running total up to, and then another running total to include the "after" portion. Of course the profit and loss accounts have to be cleared out by year - which adds a measure of complexity.
Excel is limited in functionality when it comes to pivot table formulas.
I see several approaches to this:
Maybe one of our Certified QQube Solution Providers can chime in here.
Hi Antonio,
This could be done with DAX. Running Totals.
Check ou this site...https://www.sqlbi.com/articles/computing-running-totals-in-dax/
Choose a location
Forum :
Your session has expired. You are being logged out.