OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?

Summary

I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columns

Content

I'm building an OTBI Analysis using Payables Invoices - Transactions Real Time and I wanted to know if it's possible to create a calculated column that summarizes the invoice column to show total spend by that vendor for the period of the report.

For example, I have 3 columns:

Supplier          Invoice Number       Invoice Amount

 

I want to have 4 columns

Supplier         Invoice Number        Invoice Amount        Total Spend by Supplier

 

There are some summary functions in OTBI but so far they just sum up the total but not by Suppler. I don't seem to be able to "Group By" or get anything to work in the calculated field to do this.