Hi
 
Using SQL I want to assemble a dataset (to be used by a Quick Report) that will allow me to express each group total as a percentage of the grand total. 
 
I can't calculate the percentage at the group level in the report because we don't have the total until the end, so it seems that I need to have the grand total read into the dataset.
 
Are there any tricky ways of achieving this? or is there no alternative to just doing a double pass through the dataset?
 
TIA
 
Mark
BEGIN:VCARD
VERSION:2.1
N:Howard;Mark
FN:Mark Howard
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20010925T234725Z
END:VCARD

Reply via email to