COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: t0mato on 06 Aug 2020 11:33:59 AM

Title: Summaries for Multiple Groups
Post by: t0mato on 06 Aug 2020 11:33:59 AM
Hello,

Picture the following report:

Column A - Location
Column B - Store Number
Column C - Email Address

I've grouped column A (location) to be provided a summary for each location of how many total email addresses there are associated.

The goal: I want to also group Store Number and be provided a summary for each Store Number regarding how many email addresses are there as well.

How would I go about achieving this?

The overall goal is to be able to see a summary by location of how many total email addresses are there, and also a summary by store number of how many email addresses.
Title: Re: Summaries for Multiple Groups
Post by: MFGF on 06 Aug 2020 11:58:33 AM
Quote from: t0mato on 06 Aug 2020 11:33:59 AM
Hello,

Picture the following report:

Column A - Location
Column B - Store Number
Column C - Email Address

I've grouped column A (location) to be provided a summary for each location of how many total email addresses there are associated.

The goal: I want to also group Store Number and be provided a summary for each Store Number regarding how many email addresses are there as well.

How would I go about achieving this?

The overall goal is to be able to see a summary by location of how many total email addresses are there, and also a summary by store number of how many email addresses.

Hi,

It's as simple as selecting the Store Number list column then using the Group button on the toolbar. You can group as many or as few columns as you like.

Cheers!

MF.
Title: Re: Summaries for Multiple Groups
Post by: t0mato on 13 Aug 2020 08:29:48 AM
Yep, I was doing this but just couldn't get it to display properly. Got it going now.

Thanks!


Quote from: MFGF on 06 Aug 2020 11:58:33 AM
Hi,

It's as simple as selecting the Store Number list column then using the Group button on the toolbar. You can group as many or as few columns as you like.

Cheers!

MF.