<p>I can't get this right and feel stupid about it.</p>
<p>I have a data set with lots of rows per health facility, one row per patient.</p>
<p>I created a table with grouping on health facility and created an aggegated field giving me the sum of patients per health facility.</p>
<p>Now I need to find the health facilities with the highest and second highest number of patients.</p>
<p>Using RANK must be the right solution but how do I find the rank of group aggregated fields?</p>
