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.
