Crosstab Column Totals

[stuart_adair]

Hello all,

Another one for you. I've got a crosstab query running with depots on the left and months of the year across the top. Row totals are easy but I want to add column totals at the bottom of the report.

I've tried adding a field in the page footer and the report footer and declaring it to be a running sum but nothing seems to work.

Any advice?

Thanks
Stu

 

[pbaldy]

Try this in the report footer:

=Sum(FieldName)

 

[stuart_adair]

Thats got it - Simple when you know how.

thanks

 

[pbaldy]

No problemo, glad it worked for you.

 

[tezread]

I have a similar issue and was wondering how can I then present the results in a graph. Doesn't the graph need a control source run by a query?