Author Topic: Hiding columns in crosstab creates a formatting problem  (Read 869 times)

Offline JohnnyCat

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +0/-0
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??