Crosstab in Cognos

Question

I have a set of data that needs to be displayed as a crosstab in Cognos. Example data includes

    ID, Month, Year, State
    1, 10, 2008, 25
    2, 10, 2008, 26

The problem is that in the crosstab, the month column is duplicated for each row instead of using the same column for the month.

Example:

ID   2008    2008
     10      10
1    25
2            26

Answer 1

I'm not a Cognos guy but it sounds like your detail is not wrapped in an aggregate function like SUM(x).

Answer 2

Cognos allows you to enter SQL Queries in addition of plain reporting of data. Try to dive into that

Answer 3

Can you tell us what you drug out into your cross tab by the row, column and measure drop zones? Is your data source relational data or a cube? With a little more info, I think we can figure this out.

Chris

Answer 4

Reworked the report after working on the view to keep the problem from occurring again.