Link to home
Start Free TrialLog in
Avatar of rvfowler2
rvfowler2Flag for United States of America

asked on

FM - Setting Up a Table of Sales Reports

I've been tasked with importing from Excel sales reports from our tenants.  I started designing per the spreadsheet, but thought I'd ask for best practice.  The spreadsheet is setup with column headings for the months, which translates into separate fields in FM.  However, I think it would give me more flexibility if I had one field for the amount and a field for the month (already planned to have a field for the year).  The drawback is I would have to import one month at a time (so 12 imports) so I could auto enter the month.  See attached screen print (without identifying info).
Capture.JPG
ASKER CERTIFIED SOLUTION
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rvfowler2

ASKER

Thanks, that helps.