More complicated charts
I was wondering if someone could help me with some charts. What I have is a simple database:
customer --< projects --<lineitems >--< invoice
What I would like to do is:
1) Report on the total amount invoiced for all customers within a date range. This I can do.I set up a start and end date in the customer field and related those with the customer_ID to the invoice table and summed the totals.
2) This is the bit I need some help with. How can I allow the user to select a company and show the total invoiced for particular projects for a given date range. I'm not sure which table it should be viewed from or how to quite set it up.
Thanks in advance.