I have a report with 3 grouping like this:

owner
opportunity
Account

The report is looking good with each user in separate page and total based
on owner. But i need to do grand total for all the owners which will be
report total?.

I tried to create report with subtotal and changed the grouping but still i
didn't get grand total.

Any help is appreciated.
Thanks,
Uma

Uma,

It sounds like you need a separate total in the report footer to
accomplish this. You should be able to just use the sum aggregate
function to get this to display

I don't think that you need to change the groupings in the report at
all.

Please let me know if this advice was helpful at all.

Thanks,

jt

Jt,

Thanks for reply.

I did create another dataset with just grandtotal and created
reportparameter for that field. Added that papameter in the footer.

Is that's what you are saying?.

Uma

"jmthibodeau@gmail.com" wrote:

Uma,

I'm not talking about a dataset - because you already have that to
return the data needed by the report.
I'm not talking about parameters - because these are entered by the
user before the report is run.

You're trying to return a grand total for the report - correct

The expression (aggregate function) in the report footer should be
similar to the following
Sum(Expression, Scope)
You can also try to use
RunningValue (Expression, Function, Scope)

Best of Luck - please let me know if you have any other questions.

Thanks,

jt

Hi Jt,

Thank you so much. It worked with RunningValue function!!.

Uma

"jmthibodeau@gmail.com" wrote: