Query Designer - Formulas in Results Row

Hi,

Is it possible to have a formula based purely on values in the results row? e.g.

Col A Col B Col C ColDl

Results Row 4 5 1 40%

Where Col D is Col A as a percentage of the total. I can create a formula for individual rows but not for the results row where it just seems to sum individual percentages.

Thanks