Total of a total of a total

[lizzie]

Greetings

I am in the process of creating a subsummary report which specifically looks at our sales team's pipeline deals.

While our sales consultants might quote clients on various options (all listed in one quote), it is imperative that we only take into account those items or options on the quote which we know are an almost guaranteed sale. Each quote has children which can be flagged as a pipeline item or not. I have then added these flagged items up to get a total per quote.

In the sub-summary report, I then want to show a total per category (as we have various categories which range from "Good to Best") and then a total per Sales Consultant.

I am pretty good with subsummary reports but for some reason the total for the category and the total for the sales consultants are not working.

I think my problem is as follows: I have a total of the children per quote. I have then tried to have a total of the total of the children... etc etc...

This doesn't seem right to me...

My next step is to try and use "Sum" calculations followed by using "Total of"... I do need to play around a bit more but I thought I'd "put it out there" in case I really am being a complete idiot...

I look forward to being enlightened!

Many thanks!