That subtotals the rows if their are other fields following that row (ie, red, green) it would then total the two of them for apples. It does not give the Grand Total at the bottom, unless I am doing something wrong.