Desktop productivity for business analysts and programmers

Filter out Ranking's Highest Number

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

Filter out Ranking's Highest Number


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 ?

Capture.PNG


Accepted Solutions
Solution
‎08-13-2015 07:31 PM
Frequent Contributor
Posts: 104

Re: Filter out Ranking's Highest Number

Thank you all, I figured it out.

View solution in original post


All Replies
Solution
‎08-13-2015 07:31 PM
Frequent Contributor
Posts: 104

Re: Filter out Ranking's Highest Number

Thank you all, I figured it out.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 270 views
  • 0 likes
  • 1 in conversation