Link to home
Start Free TrialLog in
Avatar of ReneGe
ReneGeFlag for Canada

asked on

Filemaker Pro - Export to Excel as Pivot Table

Hi,

I need to learn how to export a Filemaker Pro database to Excel as a Pivot Table.

Thanks for your help

Cheers,
Rene
Avatar of Will Loving
Will Loving
Flag of United States of America image

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: 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
Avatar of ReneGe

ASKER

Hi Will :)

Here is an example of what I need.

It could look like this:

Database:
date,name,produce
2017-03-01,store1,apple
2017-03-01,store1,apple
2017-03-01,store2,carrot
2017-03-02,store1,carrot
2017-03-02,store2,carrot
2017-03-02,store2,carrot

Output:
DATE              "Store1Carrot" "Store1Apple"     "Store2Carrot" "Store2Apple"
2017-03-01                0                       2                               1                   0
2017-03-02                1                       0                               2                   0
ASKER CERTIFIED SOLUTION
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ReneGe

ASKER

Hey Will,

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 :)

Greatly appreciated.

Cheers mate,
René
You're welcome, René!