by Jens Teich <spamtrap@[EMAIL PROTECTED]
>
Apr 7, 2008 at 10:31 AM
> I need new table with aggregate data groupped by Code, Bank Year and
> with total of Total:
>
>
> Code Bank Year Totale
> 123 Bank1 2007 2500
> 123 BanK2 2007 1700
> 124 BanK1 2007 5500
You don't need a new table. All you need is a summary field based on
sum of Totale and a subsummary layout part ( when sorted by Code and Bank
).
The rest of the work FileMaker will do for you.
Jens
--
Free PlugIn for Regular Expressions with FileMaker:
http://jensteich.de/regex-plugin/
