Report Logic - like dense rank function
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.