Filemaker Pro - Export to Excel as Pivot Table

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

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

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é!