Group By Supplier in OTBI

Question

Summary:

Hi!

How can i "group by" the amounts of paid invoices by supplier?

I need the "Gross Amount" to be summed to one cell of payment amount, or just present the payment amount one time per payment (Check Number).

Is there any option to GroupBy in OTBI?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Gaurav Bharadwaj-Oracle · Answer

Hi @Yftach Paschur-Oracle

By Default grouping in OTBI happens implicitly from left to right.

Meaning check the columns selected in the Criteria Tab, the grouping will happen from the leftmost column towards the right most.

To explicitly set Group By you need to use my Colleague's suggestion ie Rajasekhar's Suggestion.

Regards,

Gaurav

Riyaz Ali-Oracle · Answer

Please check the below as it might be helpful:

Payables Invoices - Transactions Real Time

How to apply "Group By" Condition on a column - in OTBI Analyis? — Cloud Customer Connect

OTBI Analysis - Invoices paid by date paid — Cloud Customer Connect

Rajasekhar Bandaru-Oracle · Answer

Hi

In OTBI (Oracle Transactional Business Intelligence) analysis, the GROUP BY clause allows you to aggregate data by specific columns, creating groups based on shared values. This is often used with aggregate functions like SUM(), AVG(), COUNT(), etc., to summarize data within each group.

Please review the given OTBI help center documentation

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/manipulate-members-groups-and-calculated-items.html#GUID-26068C5E-DE1D-42DA-801E-2653B67BEB9A