I am trying to subtotal multiple groups within a list, e.g. I would like to
subtotal sales by Product within Customers within Sales Rep. However, the
Subtotal function only works for 1 subtotal group; if I start subtotalling
more than 1 group, it goes carzy when inserting new subtotal groups and drops
out some records randomly.
Example: Group by Sales rep: no problem
Group by Customers within sales rep: the check box for Summary below data
"greys out" if I do NOT choose to Replace Current Subtotals; and the subtotal
result is incorrect because some records belong to the same custome within
the same rep are "dropped OUTSIDE" of the subtotal.