Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
replied

Hi,

use this.

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

Amit

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question