I am new to Filemaker. Am using repeating fields in an invoice. How do I analyse all the itmes used in a repeating field?

eg say from 10 records that have 5 items each in a repeating field, I would like to create a report that would group the items by type from all 10 records and have sub totals etc.

is this possible?

thanks

Look at the extend function in define fields in the online help file. But I would seriously avoid repeating fields, instead create a related table. Repeating fields lead to many problems down the line, although easier to set up initially.

You can't get there from here. This is a beginner's mistake. You absolutely need to DUMP THE REPEATING FIELDS! Filemaker is a relational database and you need to use a proper normalized data relationship with Invoice and InvoiceItem tables. There are a zillion invoice examples.