Sum based on criteria in another field

[#1]

See attached data example.  I want to be able to create a table that shows four columns summarizing

ProducerName	GWP for Brokerage	GWP for Binding	Total GWP

How do I construct my expressions to sum GWP in to 2 different columns based on the PRODUCT CLASSIFICATION field?

[swuehl · Accepted solution]

For columns GWP for Brokerage use

=sum({<[Product Classification] = {'Brokerage'}>} GWP)

and similar for GWP for Binding column.

Hope this helps,

Stefan