Repeat Customer Logic.??

[Silambarasan1306]

Hi,

I have the below data.

Year	Customer
2014	A
2014	B
2014	C
2015	A
2016	C
2017	D
2017	E
2017	A

For this i want to find repeat customer %. Help me guys.

[sunny_talwar]

What would be the expected output based on this sample data?

[Silambarasan1306]

Hi Sunny,

I want the output like,

    If A Customer is Coming today for purchasing. The same person is already purchased. So he is a repeated customer. So my value should show 100%.