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.