I'm considering using FileMaker Pro for a forecasting tool I'm working on. I need to display data in the layout shown below. Its basically like a portal but with a record displayed vertically instead of horizontally. Does anyone have experience with something similar and could recommend a good approach? Its easy to set up in Excel or Numbers, but I would like to use FMP if I can make it work.
Month 1 Month 2 Month 3 ...
Field desc 1 | data1-1 data2-1 data3-1
Field desc 2 | data1-2 data2-2 data3-2
Field desc 3 | data1-3 data2-3 data3-3
Thanks in advance!