Thank you for your post.
Create the following calculation fields:
Active = If (Attribute = "Active"; 1; 0)
Inactive = If (Attribute = "Inactive"; 1; 0)
Open = If (Attrtibute = "Open"; 1; 0)
Closed = If (Attribute = "Closed"; 1; 0)
Engaged = If (Attribute = "Engaged"; 1; 0)
Nonengaged = If (Attribute = "Nonengaged"; 1; 0)
This checks the Attribute field. If it equals "Active", then it assigns the value 1 for this record. Obviously, all other fields evaluate to 0.
You do not need to have these fields appear on the layout.
Now, create your six summary fields:
Total Active = Total of Active
Total Inactive = Total of Inactive
Total Open = Total of Open
Total Closed = Total of Closed
Total Engaged = Total of Engaged
Total Nonegaged = Total of Nonengaged
You now have six summary fields for each of the Attributes assigned.
Does that make sense?