Add a counter based on two fields

[Anonymous]

Hi,

i have the folllowing set of data

OPERATOR                       DATE
Andrew       01-DEC-17 10:40:17
Andrew       01-DEC-17 10:41:36
Andrew       01-DEC-17 10:47:21
Andrew       01-DEC-17 10:48:02
Nicole         01-DEC-17 10:51:05
Nicole         01-DEC-17 10:51:10
Andrew       02-DEC-17 10:51:15
Andrew       02-DEC-17 10:54:10
Sophie        02-DEC-17 10:55:40
Sophie        02-DEC-17 10:57:21

I would like to add a column with a progressive number based on the two fields above; the result should be like this:

OPERATOR                       DATE          PROGRESSIVE

Andrew       01-DEC-17 10:40:17          1

Andrew       01-DEC-17 10:41:36          2

Andrew       01-DEC-17 10:47:21          3

Andrew       01-DEC-17 10:48:02          4

Nicole         01-DEC-17 10:51:05          1

Nicole         01-DEC-17 10:51:10          2

Andrew       02-DEC-17 10:51:15          1

Andrew       02-DEC-17 10:54:10          2

Sophie        02-DEC-17 10:55:40          1

Sophie        02-DEC-17 10:57:21          2

Thank you in advance

[Peter_Cammaert]

In your LT calculation, skip all rows with PROGRESSIVE = 1. Those rows mean that either the OPERATOR or the JUSTTHEDATE value has changed.

BTW we prefer that you start a new discussion for every new question.