I've come up with a way to easily show totals on a query that line up with the detail columns. See line 4) below.
In setting up the BO to calculate and display this summary, I added an attribute to indicate a total line. This attribute is also used in Styles of each line in the query to apply bold formatting for total lines.
Below are the instances of the BO used to drive the query.
When the "Description Bold?" attribute = Yes, the "Count" column values summarize all the other values of each query column.
Rule to calculate the Totals line:
If Totals_4_No_App_Tested.Category='4 Totals' Then
Totals_4_No_App_Tested.Students_1_Yes=SUM Totals_4_No_App_Tested.Students_1_Yes WHERE (Totals_4_No_App_Tested.Description_Bold_YN='No')
Totals_4_No_App_Tested.Students_2_No=SUM Totals_4_No_App_Tested.Students_2_No WHERE (Totals_4_No_App_Tested.Description_Bold_YN='No')
Totals_4_No_App_Tested.Students_3_Maybe=SUM Totals_4_No_App_Tested.Students_3_Maybe WHERE (Totals_4_No_App_Tested.Description_Bold_YN='No')
Totals_4_No_App_Tested.Students_4_NotAtPSD=SUM Totals_4_No_App_Tested.Students_4_NotAtPSD WHERE (Totals_4_No_App_Tested.Description_Bold_YN='No')
Rule to calculate the details lines of the query (not totals):
If Totals_4_No_App_Tested.Category<>'4 Totals' Then
Totals_4_No_App_Tested.Students_1_Yes=COUNT Student WHERE (Student.T_020_PSD_Intent='Yes' AND Student.T_200_App_Status=Totals_4_No_App_Tested.Category AND Student.Current_Grade='8' AND Student.Status='Active')
Totals_4_No_App_Tested.Students_2_No=COUNT Student WHERE (Student.T_020_PSD_Intent='No' AND Student.T_200_App_Status=Totals_4_No_App_Tested.Category AND Student.Current_Grade='8' AND Student.Status='Active')
Totals_4_No_App_Tested.Students_3_Maybe=COUNT Student WHERE (Student.T_020_PSD_Intent='Maybe' AND Student.T_200_App_Status=Totals_4_No_App_Tested.Category AND Student.Current_Grade='8' AND Student.Status='Active')
Totals_4_No_App_Tested.Students_4_NotAtPSD=COUNT Student WHERE (Student.T_020_PSD_Intent IS UNDEFINED AND Student.T_200_App_Status=Totals_4_No_App_Tested.Category AND Student.Current_Grade='8' AND Student.Status='Active')
Drilling down to Filtered Details
When the magnifying class on any line is clicked, the user can drill down to see the underlying data supporting the totals. Below is a query showing the 62 records that are included in the "Totals" line. Note that the user can then use any of the 8 filters above the query when analyzing the underlying data:
Result when filtering the 62 records to only include "Shadow = Yes" --> 26 records to view:
