• Thanks Jake. I should have mentioned that the page we're doing this on has lots of filters. Users expect to be able to filter the page by a few different metrics and the totals update automatically. So rank and window doesn't help us there. 
  • You can use SQL functions in Beastmode (not documented though). Try this: SUM('field name')/SUM(SUM('field name')) OVER ()