Hello,
I am using cognos 8. I have a crosstab with one row field and
two nested columns. The top column is a sort key, the bottom
column is the description (a string). The measure is a count.
I need to perform a total horizontally and vertically. This is
what it looks like.
_______|Â SORT KEY | Total|
_______|Descr|Descr|Â Â Â Â |
Country|
Country| EMPLOYEEÂ COUNT |
Country|
Total |
Now I must perform the total on the column (for description) by
highlighting sort key and chossing total from the summation
icon. Then I hide the Sort Key by setting box type to none.
When I run the report the "Total" column label appears all the
way to the left (above the first column), and the totals are on
the right. This happens because I hid the sort key field.
Is there any way to fix this??