Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Group By Supplier in OTBI
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):
Answers
-
Hi
In OTBI (Oracle Transactional Business Intelligence) analysis, the
GROUP BYclause allows you to aggregate data by specific columns, creating groups based on shared values. This is often used with aggregate functions likeSUM(),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
0 -
-
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
0
