How to find newly added customer yearly ?

[shekhar_analyti]

Hi All ,

How to find newly added customer sales ?

My Requirement :

Issue :

Thanks & Regards

Shekar

[shekhar_analyti]

Quick update

....................however i can still do some purchase in year 2018 , 2019 .. but in that case i am a returning customer for year 2018 , 2019 etc and new for 2017

[sunny_talwar · Accepted solution]

Here is QV12 solution

Sales by New Customer

Sum(Aggr(If(CustomerID = Above(CustomerID), 0, Sales), CustomerID, (Year_of_Sales, (NUMERIC))))

Sales by Returning Customer

Sum(Aggr(If(CustomerID = Above(CustomerID), Sales, 0), CustomerID, (Year_of_Sales, (NUMERIC))))

[shekhar_analyti]

Thank you Guru Ji .

[shekhar_analyti]

Hi Sunny ,

Is there any way if same results can be achieved in QV11 ? We have to give solution in qv11 .

Migration has not happened , unfortunately .

Thanks & Regards

Shekar

[sunny_talwar]

Sort the data in the script