1 Reply Latest reply on Jun 25, 2018 12:02 PM by Steve Martin

    Select top 1 from combined dimensions

    Calvert Sonny Hydes

      I have three dimensions; County (List of state Counties), College (list of colleges attended by students) and ID (Student ID).  I want to select the most commonly attended college per county based on count of ID.  The end result would be a county map colored by the most frequently attended college per county. I've been able to create a table and rank the colleges per county.  I now want to select Rank 1 for each county color the map based on the top rank.