Hello and good day!
Dearest Oracle community friends,
Is there a way to show only the subtotal in OTBI?
Hope to hear in the community with solution on this.
Thanks and best regards.
Regie
Just use a pivot table instead of a table. Place Item Name in the row box and Rq Qty in the measures. If aggregation is set to "sum", you'll get what you have described.
Dearest Jerry,
Beautiful, very much appreciated and your solution provided my expected report.
Thanks much and best regards.
Hi @Regie Mercado There should be an item labeled "Measure Labels" in the Excluded drop area at the bottom of the pivot edit page. Move that into the "Columns" drop area.
Dearest Sir Jerry,
You are awesome. This is beautiful, your suggested solution works and it provides my needed report.
Hi @Regie Mercado,
Please find below a screenshot as Jerry suggested highlighted in yellow.
Can you please check if you have 'Measure Labels' in the column section as highlighted below?
Hope this help.
Thank you.
You are awesome, very beautiful. Your suggested solution is OK and I was able to get my required report. Very much appreciated.
Dearest Bhaskar,
I appreciate your response, the suggested solution of Sir Jerry works.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
