title: How do I select from a row having the maximum value in Report Builder?
body: <p>I have a gauge report built in SSRS that shows the weighted average and average of a data set returned from an SP.  In addition, I would like to show which row has the max/min values.  I can easily pull the max/min values but not the description to go along with that value.  Any ideas?</p>