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

Total Count Per Row for Each Case (HELP PLS!!)

Started by gosoccer, 14 Nov 2017 10:20:10 AM

Previous topic - Next topic

gosoccer

Hi friends,
I have a set of rows and trying to get a count of the rows per certain condition and show it in a column.

REPORT TO SHOW:
CASE ID                   CAR REPAIR TYPE                  TOTAL FRONT REPAIR
111-111-111             FRONT REPAIR                                2
112-111-2345           BACK REPAIR                                   3

DATA LOOKS LIKE:
CASE ID                CAR REPAIR TYPE                  TOTAL FRONT           REPAIR  DATE
111-111-111             FRONT REPAIR                                1                       07-01-2016
111-111-111             FRONT REPAIR                                1                       08-01-2017
112-111-2345           BACK REPAIR                                   1                       09-01-2016
112-111-2345           BACK REPAIR                                   2                        10-11-2017   

I'm using the following logic in the Calculation Definition but not sure how to have it rolled up the counts per case.
maximum(if (CAR_TYPE_CD]    = '2') then (1)  else (0) for [CAR_TYPE_DETAIL].[CAR_ID]   )

It's only giving me the counts of 1 for every case rather than roll it up to a total count for each case.

Thanks so much for your time.

Invisi

If I look at your example, you want a TOTAL on your TOTAL FRONT. Why don't you just do that?
Few can be done on Cognos | RTFM for those who ask basic questions...