Hi Wayne,

It's not so easy to answer without knowing more about the calculation in your subtotal field.

Usually you have an aggregate function like sum that you use for the group, e.g. sum(a for group 1) So to get the total sum if you use the same expression and replace "for group 1" by "for all", e.g. sum(a for all).

But I guess it is not so easy for you?

You could try this:

• Create a computed field (I call it "subtotal_helper") with following expression:
  
  if(getrow () = first( getrow() for group 1 ), subtotal, 0)
  
  
• The expression for you summary field:
  
  sum (subtotal_helper for all)

(You could also use last aggregate function instead of first.)

HTH,

René