How to Create a BI Publisher Report with Subtotals

Is it possible to create a report w/ subtotals in BI publisher? When using the table wizard, you can summarize things, but that prevents the original row from being summarized.

e.g.,

vendor    voucher   amount

00001     a1             10$

00001     a2              5$

00001     -                15$

00002     a3             10$

00002     a4              5$

00002     -                15$

-               -                $30