Skip to Content
avatar image
Former Member

Report Logic - like dense rank function

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.

dense.png (6.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 19, 2015 at 02:21 PM

    Hi,

    use this.

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

    Amit


    Untitled.png (14.6 kB)
    Add comment
    10|10000 characters needed characters exceeded