Pivoting data

[FileMaker Magazine]

While FileMaker's own Layout Mode provides excellent tools for formatting data for display and output, it isn't always the most convenient for certain types of output. A prime example is a pivot table. Or, the output of data which is normally columnar formatted into a horizontal format.

When attempting to do this with native FileMaker functionality, it quickly becomes a bit of a hassle, typically including more relationships than should be otherwise necessary.

There are solutions which can make use of repeating horizontal fields, but these typically have a hard limit and the width of the data does not dictate the largest column width. If you work creatively with HTML/CSS and the other available features within FileMaker, you can realize a more flexible solution for horizontal data display and output!

Click the title or link to this article to view the video.

View the full article