Start Free Trial
Filemaker Pro - Export to Excel as Pivot Table
I need to learn how to export a Filemaker Pro database to Excel as a Pivot Table.
Thanks for your help
* Pivot Tables
8/22/2022 - Mon
I'm not aware of any specific tool or technique that will export data from FM directly to a Pivot table. You can 1) export to Excel and then modify the spreadsheet; 2) export to Excel format and then import into an existing Excel template that has the functionality and formatting you want already estabilished. 3) Use ODBC to link an Excel spreadsheet setup as a Pivot table to a FileMaker database so that the spreadsheet reflects the data in the database.
However, you might consider simply doing the Pivot Table in FileMaker. Cleveland Consulting offers a plugin that makes this process very easy:
And there are also several techniques if you want to set it up manually, some of which are referred to here:
Hi Will :)
Here is an example of what I need.
It could look like this:
DATE "Store1Carrot" "Store1Apple" "Store2Carrot" "Store2Apple"
2017-03-01 0 2 1 0
2017-03-02 1 0 2 0
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Thanks for your detaild answer. I understand what you mean and it's a great idea.
I'll decided to go with the Pivot Table created in Excel.
Thanks for all your help :)
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
You're welcome, René!
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
However, you might consider simply doing the Pivot Table in FileMaker. Cleveland Consulting offers a plugin that makes this process very easy: http://clevelandconsulting.com/ccpivot/ And there are also several techniques if you want to set it up manually, some of which are referred to here: https://community.filemaker.com/thread/116874