The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

A report in a FileMaker Pro database generally contains fields and records from a single table. However, you can create custom report layouts that include fields from multiple tables, as long as ...