I am very new to FileMaker so please bear with me. I have created a database off of a datapull from our job costing/accounting server. I am trying to duplicate a report that I create in Excel using Pivot tables. I know...the easiest way to get a pivot table in FileMaker is to do it in Excel

So I have my data (having fun I must say with the functions) and I'm trying to create a report that kind of looks like this:

My issue: the Billable, Downtime, ASA, Internal Job, etc, etc row on the top comes from one field in Excel. I have duplicated the same calculations via functions to pull that info in Filemaker and created one field called 'Time Breakdown'.

How...do I get the Breakdown field to populate across the top of my report and down?

Or...do I need to create a field for each different breakdown of time I have and do it that way?

TIA!

I know...the easiest way to get a pivot table in FileMaker is to do it in Excel

Maybe so. Couldn't you do with the built-in summary report in the form of:

Christine

• Billable: 158.75

• ASA: 1.75

...

Kristine

...