1 of 1 people found this helpful
Are you using version 8.1?
If so, create 2 calculated fields similar to the following:
Then, place these on the view along with Sales Rank and Trans.
Hope this helps!
I am not using 8.1 so I dont see the RANK calculation option in the formulas. (Thank you!)