Crosstab Define Contents

[ghnanamk]

Hi everyone,

I've created a crosstab with three columns: A, B, and C, where C is a calculated average (A / B). The issue I'm facing is with the total row. By default, when the data is summarized, column C displays a total (sum), but I want it to show (Total A / Total B) instead.

Here's what I've tried so far:

Set 'Define Content' to Yes.

Hid the default total for column C.

Created a calculated field with the expression (Total A / Total B).

Unlocked the crosstab layout and dragged this calculated field into the total column cell.

Then disabled 'Define Content'.

However, when I ran the report, column C still displayed the average instead of the expected total calculation (Total A / Total B).

To work around this, I created a separate calculated column for (Total A / Total B) and used a singleton to display it in the total field. This worked and showed the correct result.

Issue: When I try to hide the extra calculated column using Box Type: None, the layout gets affected—specifically, the hidden column overlaps with another header in the crosstab.

Question:

 Is there a way to hide the separate calculated column cleanly—without using Box Type None in a way that affects the layout or causes header overlap?

Thanks in advance for your help!

#cognos,#DefineContent,#Crosstab,#List,#cognosreport