AnsweredAssumed Answered

Financial period comparison report

Question asked by PaulChristie on Oct 18, 2010
Latest reply on Oct 19, 2010 by philmodjunk


Financial period comparison report


Hello can someone help me please?

It is probably easier than I think but I can't quite get my head around this.

I run a manufacturing plant but sell to clients on a job to job basis.

I have tables for a job description (Job no, Customer details etc), Job parts detail (Multiple line items Qty, description etc.)

Naturally 1 customer can have many jobs with many line items in the detail.

I can generate reports with summary fields that show on single lines Customer name, Job total price for a given period.

So say for a date period of 1 month it will show for each customer the total dollar value of all jobs done in that period and show every customer in the found set .


Period, 10/2010

Name Total sales

Johns Metals $30,000

Pauls metals  $300,000.00


What I want to do is show comparative periods on the same report so we can have say the following

Name Oct Nov Dec

Johns metals $30,000 $20,000 $500

If anyone can help I would be much obliged

Thx, Paul