Creating a rolling twelve month report
I'm brand new to Filemaker Pro. My company supplies me my sales data in either an Excel or .csv format. I've figured out how FMP can import the file, but I'm having problems. Each month from the last 5 years has its own column for both the quantitiy I sold and the dollar value. I would like to organize my data in a rolling twelve month report: the column headings would be:
Manufacturer of Product
Product Package Size
Under each month would be a cell for the lbs sold, and one for the $ amount, with totals for each customer.
I would like the report to only include the last twelve months data. Is there a way to do that?