Select date problem

[#1]

Hi,

I have two tables: customers and orders.

Customer:
===========
customer_id,
customer_name,
customer_since
customer_since_month
customer_since_year


Order:
=======
order_id,
customer_id,
order_date,
order_month
order_year
order_amount


I'd like to show my figures based on the customer_since_year and customer_since_month selections.

If I select 2009 and Mar (in customer table) I'd like to show a table chart that shows me the order_amount (based on the order_date).

e.g.

orderdate amount
======================
mar_09 10.000
apr_09 13.000
may_09 23.000
jun_09 14.000
aug_09 12.000
sept_09 4.000
oct_09 32.000

Can someone tell me how to do this?
Thanks in advance

Aloah

[#2]

Hi,

Link both the tables on only customer_id.

add list box for customer_since_year and customer_since_month so that you can make selections.

Now in chart add order_month as dimenssion and sum(order_amount) as expression.

Thanks & Best Regards,

Kuldeep tak

[#3]

uh. i missed something - SORRY. in table customer there's an salesperson

Customer:
===========
customer_id,
customer_name,
customer_since
customer_since_month
customer_since_year
salesperson

Order:
=======
order_id,
customer_id,
order_date,
order_month
order_year
order_amount

The information I'd like to show the order amount of new customers per salesperson.
I select a salesperson, an new customer since year (and month) and would like to see the orders the new customers made in 2009.