Print Page - Grand Total in Cognos Crosstab (10.2)

Title: Grand Total in Cognos Crosstab (10.2)
Post by: Cognosuser2019 on 02 Sep 2015 10:28:02 AM

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

Title: Re: Grand Total in Cognos Crosstab (10.2)
Post by: Vivekmore23 on 03 Sep 2015 05:48:22 AM

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

Title: Re: Grand Total in Cognos Crosstab (10.2)
Post by: Cognosuser2019 on 04 Sep 2015 01:25:48 PM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognosuser2019 on 02 Sep 2015 10:28:02 AM