Print Page - how to get subtotals in list report

Title: how to get subtotals in list report
Post by: Mahendra on 09 May 2011 01:06:23 AM

Hi gurus,

I have a list report with three columns like country,state and revenue, on country i have made section for every Country i need subtotal how to get this .. please help me

Thanks
Mahi

Title: Re: how to get subtotals in list report
Post by: PRIT AMRIT on 09 May 2011 01:43:02 AM

You have to get the subtotal first and then section it. Which means,

1. Select Country and apply Grouping
2. Select Revenue and apply Aggregation 'TOTAL'
3. Select Country and apply Section

If you don't want to the Summary Row, you may select the Row and delete it.

Hope it helps?

Thanks
Prit

Title: Re: how to get subtotals in list report
Post by: Mahendra on 09 May 2011 04:17:04 AM

Hi PRIT,

Thanks a lot its working fine now....

Regards,
Mahendra.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mahendra on 09 May 2011 01:06:23 AM