Pivot table reporting is very difficult to do in FileMaker. The process requires a complex combination of portals or repeating fields, ExecuteSQL, and sometimes calc fields. It’s a tough report to build, and many of our clients request export features to manipulate their data within Excel and build a pivot table externally. That’s quite a few steps just to see your data.
Fortunately, we’ve uncovered a method to creating a pivot table directly in FileMaker through a PivotTable.js integration, simplifying and speeding up the process. Explore our demo of its key functionality to learn how to implement the integration in your own FileMaker implementation.
Don’t forget to read Jeremy Brown’s step-by-step guide on how to use this demo to your full advantage.