OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?
SummaryI'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
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.