No, this cannot be done by a sub-summary report, because you don't have enough records to produce such report. You need to create a related record in another table for each association of an issue with a sector, and produce your report from there.
Thank you for your post.
The reply from "comment" is correct, but there is another way to achieve the same results, although it is not the ideal way.
You can create calculation fields for each of your checkbox entries, and then use a summary field to add up each of those checkbox fields. Using your example, you would have three calculation fields:
FieldA = If (PatternCount ( checkboxfield ; "FieldA" ) > 0 ; 1 ; 0 )
FieldB = If (PatternCount ( checkboxfield ; "FieldB" ) > 0 ; 1 ; 0 )
FieldC = If (PatternCount ( checkboxfield ; "FieldC" ) > 0 ; 1 ; 0 )
Then, create a Summary field for each of the calculation fields. That is,
Total FieldA = Total of FieldA
Total FieldB = Total of FieldB
Total FieldC = Total of FieldC
This will get you the desired results, but this does add a lot of extra fields to your table, especially if you have a Checkbox field with MANY options.
So how did the layout for the subsummary report work.
i'm having the same issue and am able to keep an accurate count, but when I run a report based on the values inside the checkbox list, any item that has more than one box checked does not duplicate. So using the initial example:
If Issue A has agriculture and business checked off
and Issue B has agriculture and Industry checked off, the ideal report would look like this when sorting by checkbox field:
However when I'm running mine, if the record has more than one value checked, the value only shows up in the first. so my report is looking like this: