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