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

Report Summary based one single-field with numerous values

Started by AUjamiebutler, 06 Dec 2023 02:29:00 PM

Previous topic - Next topic

AUjamiebutler

I am new to the community, working on a report pulling numbers by County. I have one field "county" that has the name of a county. Trying to pull this into a report summary and show a list of each county name that is in the database with the corresponding count for each (i.e. Riverside appears 10 times and San Mateo appears 3) I need to show the counts for each county that shows in a list.

The counties change weekly in our database with new records and such, I don't want to create a count for each county with it always changing.

Can I break out each unique county name and create a count? Any assistance is greatly appreciated.

MFGF

Hi,

You could try adding a Query Calculation to your list with an expression of 1. In the properties of the column, set both the Detail Aggregation and Summary Aggregation properties to be Total.

Does this give you what you need?

Cheers!

MF.
Meep!

AUjamiebutler