Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Pls help me for below logic

pls help me for below logic.

i have two types of customer i.e. new customer and existing customer

i want to show New vs Existing customer sale , month wise

now if i am showing New vs Existing sale in month of April than in next month new customer of april would be shown in existing customer of May and so on.....

pls pls do help me for that logic...

5 Replies
MK_QSL
MVP
MVP

Provide sample data... New and Existing Customers need to be classified in the script itself...

abhaysingh
Specialist II
Specialist II
Author

i have customers and i have segregated on the basis of date.

i.e. customer those are enrolled after 31 march 2014 are new customer and rest of old customer

abhaysingh
Specialist II
Specialist II
Author

* old customer = Existing customer

MK_QSL
MVP
MVP

What is your CustomerJoin Date looks like.. i.e. what format...? DD/MM/YYYY or DD MMM YYYY or any other?

avinashelite

Hi Abhay,

Please post the sample data.

Regards,

@vi