Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer
76
Views
4
Comments
edited May 15, 2019 9:17PM in Reporting and Analytics for ERP 4 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!