Grand Total in Cognos Crosstab (10.2)

[Cognosuser2019]

Hi All,

I have a crosstab report which is based of a relational package. I have the subtotals for two columns in crosstab. I now need to get the Grand Total. Can anyone please provide some inputs on how to achieve it.

Please see attached Sample Data. Appreciate your help with this. The package is relational.

Thanks,
Reshma

[Vivekmore23]

Hi Reshma

Add a Query Calculation to end of the cross tab where you want grand total. in the Query Calculation specify the aggregate of the measures. e.g. in this case. 

total (Measure 1 for Priority) + total (Measure 2 for Product Line)

Basically you need to replicate the aggregation and add them

Try this and let us know how it goes.

Thanks
Vivek M

[Cognosuser2019]

Thanks Vivek.

total (Measure 1 for Priority) + total (Measure 2 for Product Line) did not give me the expected result. But i tried within set and it worked.

total (Measure 1 within set Priority) + total (Measure 2 within set Product Line)

Thanks for your inputs.