Thanks for your help on this. Your solution would work if OBIEE would cooperate! I've passed this issue to our tech folks to see if they can resolve it. (Or apply a bug fix.)

I've never been taught what selection steps could be used for. Very cool. What you suggested works perfectly for the hard coded value. But, attempting to use a Presentation Variable will change the company name, but I'm back to RANK = 1. Here is the Step I set up: If I run the analysis on it's own, I get the correct…

Thanks for responding. I must not understand your solution correctly. If I try to filter the RANK calculation for just one customer, I always get a RANK of 1. I want to figure out how to get the correct RANK to be returned for a single customer, much like a VLOOKUP would do in Excel.