Aggregating responses is sometimes difficult with InfoPath.

I have found using a backend database works the best since you have many
options of how to utilize the data.

http://www.infopathdev.com/forums/p/6657/24500.aspx#24500
Here is a thread along the same lines.