How do I create a report with totals by type? Connect offers a sum option in the vertical columns grid that lets you get the sum of an amount such as fees paid and group it by type.