If you have a table like this:
Name | Item | State
Alice | Apple | Alabama
Ben | Banana | Alabama
Caitlin | Cherry | California
Assuming you have created polygons based on the states, how could you create an 'info window' which combines the details of all rows in the same state? So for example, the popup for Alabama might be something like:
State: Alabama People: 2 Items: Apple, Banana
As far as I can tell, the default behaviour for Cartodb would be to place one polygon on top of the other, and for the info window to display the info from the top most polygon only.