nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Support for subtotalling by individual date

Alan5

I have a need to produce reports where the subtotalling needs to be by individual date not a range of dates like weekly, monthly, etc. I am looking for the total of all transactions selected by the date of that transaction. The results would therefore not have any totals (or zero totals) for dates which had no transactions.

Currently, I have export transactions to a spreadsheet and run a pivot table to aggregate transactions by individual dates.

Find more posts tagged with

Reports

Windows

Reviewed

Display/UI

Status: Reviewed

Comments

Jim_Harman

You should be able to use the report at Reports > Net Worth and Balances > Net Worth.

Set the interval to Daily and on the Advanced customization tab, un-check the Include unrealized Gains box. The report has a maximum of 250 columns, so you must set the date range accordingly.

Export to Excel and subtract adjacent columns in the totals at the bottom to see the net transactions for each date.

Does this work for you?