cross tab totals

[rita73]

hi,

I have successfully created a crosstab with three  variables in row group and one in column group( that's date). the measure variable is some revenue calculated over the group variables. I have total revenue showing at the bottom of each date column. If I want to show the total at the top of the column for each date, how should I do it. Simply moving the 'total 'cell to the top doesn't help. The total stops showing completely in the published report then.

Any suggestions will be great!

[baggypants]

In the Column Group properies there is a setting for total at the top or bottom.

[rita73]

It works.

I needed to change the row group properties though.

Thanks