Hi all,
I'm trying to create a count of transactions by client ID so over a period of time we would expect a client to have made multiple payments, what I need to do is number them in order of date so essentially my data will look like the below with the transaction number being the variable I need to create
Client ID Payment Date Amt Transaction No.
100 01/01/2016 50 1
100 01/02/2016 65 2
100 01/03/2016 40 3
200 05/02/2016 100 1
300 01/03/2016 75 1
300 01/05/2016 25 2
I've had a go at using a count and if formulae, but, struggling to get it to count up for each transaction and then start the count again based on a change of client ID.
I hope this makes sense! and any help you can provide would be much appreciated.
Thanks
I'm trying to create a count of transactions by client ID so over a period of time we would expect a client to have made multiple payments, what I need to do is number them in order of date so essentially my data will look like the below with the transaction number being the variable I need to create
Client ID Payment Date Amt Transaction No.
100 01/01/2016 50 1
100 01/02/2016 65 2
100 01/03/2016 40 3
200 05/02/2016 100 1
300 01/03/2016 75 1
300 01/05/2016 25 2
I've had a go at using a count and if formulae, but, struggling to get it to count up for each transaction and then start the count again based on a change of client ID.
I hope this makes sense! and any help you can provide would be much appreciated.
Thanks