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 Analytics and AI

Child Item

OTBI - SHOW ONLY SUBTOTAL

Regie Mercado

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

Jerry Casey

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.

Regie Mercado

Hello and good day!

Dearest Jerry,

Beautiful, very much appreciated and your solution provided my expected report.

Thanks much and best regards.

Jerry Casey

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.

Regie Mercado

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

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26921/otbi-show-only-subtotal

Hi @Regie Mercado,

Can you please try the following?

Duplicate your existing view and take out (put into the excluded column list) 'Work Order' column, the analysis should show the total based on 'Report Date' & 'Item Number'.

Hope this help.

Thank you.

Regie Mercado

Hello and good day!

Dearest Bhaskar,

I appreciate your response and tried your suggestion but it is not giving me the required output. This is the sample view I want to achieve. Only the details in subtotal should appear in the report.

Hope to hear again your comment Sir and if you have other possible solution to achieve this.

Many thanks and best regards.

Regie

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70456#Comment_70456

Hi @Regie Mercado,

Can you please remove 'Work Order' & 'Report Date' columns from the Report? So your report should have only 3 columns: Item Name, Required Quantity, Primary UOM.

Please try to see how the data gets aggregated.

Thank you.

Regie Mercado

Hello and good day!

Dearest Sir Bhaskar,

Thanks much again for taking time to reply. I've already excluded the two fields but it is not giving the required output.

Many thanks and best regards.

Regie

Regie Mercado

Hello and good day!

Dearest Sir Bhaskar,

I only wanted items with check in the image to appear in the report. Hope you have possible solution.

Thanks much and best regards.

Regie

Jerry Casey

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.

Regie Mercado

Hello and good day!

Dearest Jerry,

Beautiful, very much appreciated and your solution provided my expected report.

Thanks much and best regards.

Regie Mercado

Hello and good day!

Dearest Jerry,

One more thing, hope you can help. I've notice there is no heading "Required Quantity" for the field in Measures, how can I make the heading appear also just like in "Item Name". Hope you can help.

Thanks and best regards.

Regie

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70487#Comment_70487

Hi @Regie Mercado,

Can you please attach the Report XML / catalog here so that issue can be replicated and will be helpful to find the resolution?

Thank you.

Jerry Casey

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.