Classifiy new/old Customers

[#1]

Hi,

I have a table that shows me the customer, orderdate, amount

How can I classifiy based on the current year if a customer is a new customer (orders only in 2010) or an old customer (orders before 2010)

Thanks for your help.

Kind Regards.

Aloah

[#2]

You would probably need a combination of the TOTAL command and Set Analysis. Something like this:

Sum({<orderdate={'<$(=MakeDate(Year(Today())))'}>} TOTAL <Customer> Amount)

That should give you the total amount of sales prior to the current year. If that is greater than zero, then they are repeat customers.

EDIT: I wasn't sure how you were handling selections, so I left it as the default (respect selections).

[#3]

Hi,

I'm trying to get a field that shows be, based on the selected year if a selected customer is
a new or old customer.

E.g. I select 2009, bar chart show me sales amount for new customers = 40%, old customers = 60%.

Thanks