nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Oracle AI and Analytics

Child Item

Child Item

OTBI - SHOW ONLY SUBTOTAL

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

Find more posts tagged with

Accepted answers

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.

Hello and good day!

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.

Hello and good day!

Dearest Sir Jerry,

You are awesome. This is beautiful, your suggested solution works and it provides my needed report.

Thanks much and best regards.

Regie

All comments

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.

Hello and good day!

Dearest Sir Jerry,

You are awesome, very beautiful. Your suggested solution is OK and I was able to get my required report. Very much appreciated.

Thanks much and best regards.

Regie

Hello and good day!

Dearest Bhaskar,

I appreciate your response, the suggested solution of Sir Jerry works.

Thanks and best regards.

Regie

Hello and good day!

Dearest Sir Jerry,

You are awesome. This is beautiful, your suggested solution works and it provides my needed report.

Thanks much and best regards.

Regie

Top Leaders

Rahul Bhavikatti 50

MandeepGupta 20

Moamin Shadid 15

Clark Menard 15

Top Questions

Receiving error when setting up SFTP Delivery Channel
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Session Variables for Use in Activity Center Visualizations
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
Recruiting Real Time and Real Time Events
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
No Option to Export to Excel after 26B
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
OTBI Report - need to fetch the Worker Historic information
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?