I’m trying to make an Excel sheet in FMP so we have historical data that we can build different reports. I’m having problems replicating the format. It’s a simple Sales vs Goal tracking report. It looks like this:
Salesperson Wk 1 Sls wkly Goal Wk 2 Sls wkly Goal Wk 3 Sls wkly Goal Wk 4 Sls wkly Goal Mnthly Sls Goal for Month
Amy 1000 2000 900 2000 1100 3000 1000 2000 4000 9000
Bob 2500 2500 4000 2500 4500 3500 2000 2500 13000 11000
Totals: 3500 4500 4900 4500 5600 6500 3000 4500 17000 20000
At this point I have a simple table with these fields:
So, this is simple to do in Excel, but in FMP the records want to go down instead of down, then in columns. Any tips on how to make this work?
What you are referring to is a cross tab report. If you google 'Filemaker cross tab report' you'll find examples. The other method would be to do a report in a Web Viewer.