Hi! I'm attempting to create a Crosstab in a form as follows.
Columns: Two measures (1 or 0 only)
Rows: 8 measures (1 or 0 only)
The Crosstab I desire is 2 columns, 8 rows, where the inner cells are the total(column * row)
Basically I want the intersection of these categories.
When I put them in a Crosstab, each row is the exact same value for the columns, the intersection isn't being measured.
Ive been able to create a query calculation for each row where it's total(row1 * col1) but I will have to do this calculation to manually create each cell, which is time consuming.
Does anyone know of a more efficient way to approach this? I'm happy to provide more information, but am unable to post real time images of the data as they are of a sensitive nature.
Thanks so much!
Hello!
Can you create a report with your use case against a Cognos Samples datasource and attach it here?