I can imagine a number of different ways that you might set that up.
ExecuteSQL could produce such a count.
A self join on the State field, or using a calculation field that always returns "MI" could also be used.
IN other cases a summary field in a filtered portal might be used
And a summary report could give you a list of one row for each unique value in the state field with a count of how many records with that value in that row.