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.
If I look at your example, you want a TOTAL on your TOTAL FRONT. Why don't you just do that?