I have numerous records in 1 table. I have many different record types and each record may be 1 of two different status values - 'A' or 'B'. I want to print 1 line for each record type. I want that line to show the type and the total # of records for each type and the total # of status values found within each record type (grouped).
I can easily build this report if I show each record status value count on a separate print line below the grouped record type.
The user would like to see 1 line only - I have tried using a number of different CALCULATE fields definitions, but have not found the proper combination.
this is a sample of output required
RecType RecTypeDesc TotalRecs TotalStatusA TotalStatusB
I can get a total of either statusA or satusB per rectype, but not a total for both.
Thank you for help
I can easily build this report if I show each record status value count on a separate print line below the grouped record type.
The user would like to see 1 line only - I have tried using a number of different CALCULATE fields definitions, but have not found the proper combination.
this is a sample of output required
RecType RecTypeDesc TotalRecs TotalStatusA TotalStatusB
I can get a total of either statusA or satusB per rectype, but not a total for both.
Thank you for help