Resetting Running Total Field value based on other fields

[rahulpawarb]

Hello Friends,

Hope you are doing great!

In below screenshot, I have Rank field, which needs to be corrected. Currently it is showing RowNo for each record. I want it to populate it based on below condition.

- It should start with 1 for each FGrp#, increment by one for each Sales value (Sales in descending order i.e. Highest sales in given region will listed first in the list)

- If there are same Sales values in given FGrp# then same Rank values needs to be assigned to both the records.

Present Situation:

Please refer attached application, sample data and expected result sheet for your reference.

Looking forward to your affirmative response.

Regards!

Rahul

[rahulpawarb]

Thank you I will have a look at it.

Regards!

Rahul