Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: OTBI - SHOW ONLY SUBTOTAL
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.1 -
Re: OTBI - SHOW ONLY SUBTOTAL
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.1 -
Re: DV Calc using Power inplace of Root
If I use POWER(XXXX,1/3), I get 1.00. If I use POWER(XXXX,0.33333) I get the correct (approximate) answer.2 -
Re: divide two row values using same column of OTBI analysis
Use a filter formula in each column of a single row. e.g.: FILTER ("Salary" USING "Title" IN ('CEO')). Do the same for Employee. Use a third column to divide one column …1 -
Re: Ability to tune "use as filter" over its impact for each viz on the canvas
I'd like to display 3 tables in increasing levels of detail, using each as a filter for the next. Can't do it without this change requested above.1
