Calculate does work but I need to have multiple calculations by group. And the group is based on the result set so there is no way to use calculate.