Summary calc's needed of all records when in found subset
I have a table of $ transactions. In one layout I display all records and the summaries that total on the amount field represent an ongoing balance, or total at the bottom.
If I have a found subset of the $ transactions, is there any way that I can get the ongoing balance for the whole set of records?
For example, the records represent charge and payments, with the summary field reflecting balance due. If I'm only showing the current month of charges/payments, can I still get at the ongoing balance since the start?