title: Max group value in Webi report
body: <p>I have a report in Webi 4.0 with Store name and sales revenue per store. I have created a text box and I want to display the Store name with the highest sales revenue. I can get the max value to appear with:</p>
  
  <pre><code>=Max([Sales revenue]) IN ([Store name])
  </code></pre>
  
  <p>This successfully shows me the highest sales revenue but what I want is the actual store name that corresponds to that value?</p>
  
  <p>Any help would be much appreciated.</p>
  
  <p>Thanks!</p>