COGNOiSe.com - The IBM Cognos Community

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.

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.