I am trying to get a final total from a group using a Running Total yet that field does not appear as a field I can run a total on.  Is it possible to use running totals on summary fields?

I do have groups already and what I am doing is taking two group totals and trying to total a group total.  Hard to explain.

Here is just a sample:

There is no problem giving you the data you need to help with my problem.  I just don't know how to post what you are looking for?  Is there a way to email you the query or even what the page looks like?  I am unaware how to post they way you need me to.

The problem I am having is that they want to now pay commissions on the total sale and not on the item level which is what we had been doing previously.  The reason for this is that we do sell some assembly items which show a zero selling price with a cost showing negative profitability and then the main item showing a very high profitability.  We need that to be totaled and the only way to do this is to get a sum of the total invoice.  It is not that complicated mathwise, just creating a Crystal that will do the math.