1 Reply Latest reply on Jun 17, 2016 9:25 AM by SteveMartino

    Need some tips on how to replicate Excel sheet

    JohnNiebler

      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