AnsweredAssumed Answered

Creating a rolling twelve month report

Question asked by Philosofy on May 31, 2012
Latest reply on Jun 20, 2012 by Philosofy

Title

Creating a rolling twelve month report

Post

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:

Customer

Manufacturer of Product

Product Name

Product Package Size

Month

 

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?

 

Thanks!

 

Phil

Outcomes