Use Trailing Grand Summary data in other calculation??
I have a report which selects data from records sorted from a range of dates. Works perfectly after help from the Filemaker Masters (grovel, grovel!).
Now I want to use data from a traiing grand summary (which gives the grand total of summary fields [running with restart]) in a separate calculation field.
I have set up a simple calculation in which I want to use the trailing grand summary. I can easily use the summary field, but this does not give me the grand total, as there is not a separate field for it, but merely the last iteration of a summary by date.
How can I set up a calculation which uses the (treailing grand) total of the summary field after it has been limited by a sort?