I have some data which looks similar to the below:
Date | Customer | Result |
01/01/2020 | 111 | Result1 |
01/01/2020 | 111 | Result3 |
03/01/2020 | 111 | Result4 |
04/01/2020 | 122 | Result1 |
04/01/2020 | 111 | Result1 |
06/01/2020 | 111 | Result5 |
Basically we require to count all results1-4 for each customer however if the result is result5 the counter will then reset back to zero.
Tried doing this as an AutoNumber and other methods but couldn’t figure out how to do this, does anyone know how this could be done?
