jc - fix for sort by revenue and misc view cleanup