Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
For columns GWP for Brokerage use
=sum({<[Product Classification] = {'Brokerage'}>} GWP)
and similar for GWP for Binding column.
Hope this helps,
Stefan
For columns GWP for Brokerage use
=sum({<[Product Classification] = {'Brokerage'}>} GWP)
and similar for GWP for Binding column.
Hope this helps,
Stefan