What you're trying to create is called a "crosstab report". There are several ways of creating one in FileMaker, but they're not typically straightforward.
In your case, based on your setup, you'll want to create not one, but 12 Month fields to use as parent-side joins. (Global fields are probably best.) You'll also need 12 separate table occurrences of the Bearing House Scrap Monthly Totals, one being the "target" of each of your 12 global fields.
Then run a script to populate them with the appropriate months. Put the 12 portals side-by-side, as you suspected. Point each portal to the appropriate related TO.
Just for your edification, some of the other methods for creating a crosstab report include:
- Using repeating fields to create the array of values
- Using a Virtual List technique with a given number of columns
- Using HTML code and a Web Viewer
There's a good section on creating crosstab reports in the FileMaker Training Series (Advanced). Might be worth a look.
Hi Mike, I have never heard of Crosstab Reports before so I will look up how to do this.