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 .
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