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.
We have built an OTBI report intended for Line Managers to view their subordinates’ emergency contact details. The report uses the Workforce Management - Person Real Time subject area. When a Line Manager runs the report, the emergency contact fields (e.g. EC Phone Type, EC Phone Number, EC Email Type and EC Email Address)…
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
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…