Print Page - How to add a second group by

Title: How to add a second group by
Post by: erics on 18 Jul 2016 02:30:25 PM

Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

Title: Re: How to add a second group by
Post by: MFGF on 19 Jul 2016 03:00:35 AM

Quote from: erics on 18 Jul 2016 02:30:25 PM
Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

Hi,

Assuming you are using the Aggregate button on the toolbar, I'd expect you to get summary footers for all previously grouped items (plus an overall footer for the report). If not, something odd is going on in your report...

MF.

Title: Re: How to add a second group by
Post by: Grayson_Basil on 21 Jul 2016 10:49:46 AM

Quote from: erics on 18 Jul 2016 02:30:25 PM
Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

In addition to the above comment

Try putting the region and team at the far left, then group, then total.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: erics on 18 Jul 2016 02:30:25 PM