see the attached
I added your calculation for rank to the second sheet
I also added the profit ration to the second sheet just as a check - you can just leave it out and hide the ranking
it returns this
Thank you for the comment, but I think I'm still looking for something else. I'm trying to get to an end result that is the middle of my above attached screenshots.
In general, I want to have two sheets: Sheet A and Sheet B. Both are sorted by Measure A. When using the filter action on Sheet B, I want a different measure, Measure B, to show on Sheet A.
Hopefully that makes sense.