Add an extra total to a crosstab

[calson33]

Environment - Dimensional relational queries (SQL) ans cognos 10.2

I have a crosstab with values based on different locations for a certain day.
At the bottom is a total for the entire day.

I would like to add another total line below this which would have the total amounts for the previous day for comparison.

Can this be done?

Thanks!
John

Edit: Still got weekend brain.. Meant relational queries not dimensional.