Two Flags Intersection in Crosstabs

[MaxTheDuck]

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!

[Andrei I]

Hello!
Can you create a report with your use case against a Cognos Samples datasource and attach it here?