Create a new field with a rolling count

[jillvecc]

I need to generate a new field for a rolling count, grouping by member and transaction date and break on year (reset counter) .  I have created a field for year that I can use, but I am not sure what tool to try and how to accomplish this.  Any help would be greatly appreciated!  Thanks!

Member	Transaction	Rolling Count
A2	2/29/2016	1
A2	5/3/2016	2
A2	6/23/2016	3
A2	11/6/2016	4
A2	5/21/2017	1
A2	5/22/2017	2
A2	6/1/2017	3
A3	3/19/2016	1
A3	9/5/2016	2
A3	10/22/2016	3
A3	4/4/2017	1

[ivoller · Accepted solution]

Perhaps you could use the Running Total tool? Maybe by setting up a field for year and a new column that contains 1 for each record. Then grouping by year and member and summing the new field.

Iain

[vishwa_0308]

Here is your solution.

 1. take out the year in an another field(say Year): Use Formula tool

       Right([Transaction],4)

 2. Use Tile tool, method will be "Unique" and Unique fields will be Method and Year.

Thanks,

Vishwa

[jillvecc]

Thank you!

[jillvecc]

Thank you for the suggestion.