08-13-2015 05:42 PM
I ranked Guest account based on their playdate. So a guest first playdate is ranked as 1; second playdate is ranked as 2, and so on. I got million of rows of data and I want to get the highest ranked number of the guest's.
Please see image below of the sample data. Now what I want is to take GuestNumber 103726's highest ranked number which is 75 and bring it to another dataset. How do I go about to do that ?
Need further help from the community? Please ask a new question.