If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summaries for Multiple Groups

Started by t0mato, 06 Aug 2020 11:33:59 AM

Previous topic - Next topic

t0mato

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.

MFGF

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.
Meep!

t0mato

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.