COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos74 on 12 Jul 2016 02:22:54 PM

Title: Crosstab Section Grand total
Post by: cognos74 on 12 Jul 2016 02:22:54 PM
Hi

I have a crosstab with grand total. but I need to separate each group by doing section. when I am doing the section I am losing my grand total. is there any way I can see subtotal and grand total with section in crosstab.

Thank you..
Title: Re: Crosstab Section Grand total
Post by: schrotty on 12 Jul 2016 04:24:37 PM
Hi cognos19,

Do you have a Dimensional or relational Model?

In a relational model do you have tried something like total([measure] for report)?

Schrotty
Title: Re: Crosstab Section Grand total
Post by: sdf on 12 Jul 2016 07:37:24 PM
can't you just create a grand total data item?