Report Logic - like dense rank function

[Former Member]

Hi

Please check the below screenshot. I need to get a logic to populate data as like Result column which is highlighted in yellow.  This logic is based on Field1, field2 & Sample.

Here value A has 2 sample X & Y so it should populate 1 and 2 in the result. for B we have only z so it should populate 1 and so on.

[amitrathi239 · Accepted solution]

Hi,

use this.

=RunningCount([Field3];([Field1]))In ([Field3];[Field1])

Amit