AnsweredAssumed Answered

Need some tips on how to replicate Excel sheet

Question asked by JohnNiebler on Jun 17, 2016
Latest reply on Jun 17, 2016 by SteveMartino

Hello all,

 

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:

Salesperson       Text

WeekOf              Date

SalesForWeek   Number

GoalForWeek    Number

 

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?

 

Thanks,

-John

Outcomes