In thinking about this, you probably should not be using fields such as Total Order/Dollar Value for the summary operations you currently are doing. If you have detail in your View (item number, etc), then you really should be using fields like Extended Price, Extended Order Price and using the Total summary operation (not average). Because the sum of the details should be equal to the total (and if not, an integrity error would exist in your data), you should get the same number in the Total by Document # row as the Total Order/Dollar Value.
And also as Andrew posted above, SalesAnalysis keeps track of all sales (invoices and credit notes) at a detail level, making all of this fit nicer with GridView.
_________________________
Regards,
Softrak Tech Support