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

Trying to create a summary report

Started by ganguskhan, 29 Jul 2016 09:57:13 AM

Previous topic - Next topic

ganguskhan

Good Morning,

I'm trying to create list report with counts of each class. I've created my list but unsure how to get my results if it should be a query calculation or or just be a count. 



Location   Vehicle Make   Vehicle Model   Vehicle Class   Count of vehicle class
Baltimore, MD   Chevrolet   Silverado   PICKUP
Baltimore, MD   Chevrolet   S10   PICKUP
Baltimore, MD   Chevrolet    Tahoe   SUV
Baltimore, MD   Chevrolet   Suburban   SUV
Baltimore, MD   Chevrolet   Equinox   SUV
Baltimore, MD   Chevrolet   Camaro   SPORT
Baltimore, MD   Chevrolet   Corvette   SPORT
Baltimore, MD   Chevrolet   Malibu   SEDAN
Baltimore, MD   Chevrolet   Impala   SEDAN
Baltimore, MD   Chevrolet   Cruze   SEDAN

Any help will be appreciated.

ganguskhan

I figured it out.
Created a list report with Data Item counting each record as 1.
Then I used the cut function on the model column to get my count for each type of car for my summary.

that's what I get for overthinking it.