I want to count how many times a client transacted. I need to count how many occurrence of a client by date.
Here is a sample
a b c d
Date ID ID Client AMT
1/10/2018 969677 C 1000000
1/10/2018 969678 C 1000000
1/12/2018 969776 C 1500000
1/12/2018 969777 C 3000000
1/12/2018 969778 C 500000
1/17/2018 969885 C 2000000
1/17/2018 969886 C 4000000
1/17/2018 969887 C 500000
1/18/2018 969963 B 6000000
1/18/2018 969965 C 1500000
1/18/2018 969966 C 500000
1/19/2018 969988 A 2000000
1/2/2018 969094 C 4000000
1/2/2018 969096 C 3500000
Bookmarks