Total help

[Geordie2008]

Morning all,

I have a report based on a cross tab.

I have managed to sort of a total by column....

How do I get a total by row?

E.g. My row is sales person. My Column is Sales Country.

I can get a total per country, but how do I get a total per sales person?

Many many thanks,
I have tried all sorts to try and get this to work....
Mandy.

 

[statsman]

With the report in design view, insert a blank text box from the toolbar and place it into the position you want.

Go to the properties of the text box and enter in the Source Data field:

=Sum([fieldname])

 

[Geordie2008]

It just gives me a data type missmatch..

Problem Looks like this:

_______Asia_____Europe
CP_____12_______2
MC_____10_______6
SJ______3_______10
Total___25_____18


and I want:

_______Asia_____Europe___Total
CP_____12_______2________14
MC_____10_______6________16
SJ______3_______10________13
Total___25_____18________43

Thanks!
Mandy

With the report in design view, insert a blank text box from the toolbar and place it into the position you want.

Go to the properties of the text box and enter in the Source Data field:

=Sum([SalesPerson]) it can sum text. And if I put sum([Europe]+[Asia]) it put the same value in for all of the sales people.... (not by each sales person)

Any advice appreciated!
Mandy

 

[Rich]

Add another column to the crosstab