Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 12, 2013 4:51 AM by
Jan 11, 2013 3:40 PM
Here is my issue. No one has been able to solve this.
I have two columns: Parent Company Limit (column A) , and Child Company Limit (column B)
The subtotal of column B is actually not the REAL limit of the Parent (the sum of children don't equal the parent) ....
So, I need a way to have the subtotal of column B POINT to the average of column A.
How I need it in Report
Subtotal for MSTF,10000
This was doable in MicroStrategy but haven't been able to reproduce in OBIEE.
P.S.: I'm not looking for a level-based metric.
This content has been marked as final.
Show 1 reply
Re: custom subtotal
Jan 12, 2013 4:51 AM
in response to
You cannot use Subtotal for this...
USe Union reporting.
in the first Union
first Union : 1 , Company , B
2nd Union : 2 , Distinct Company , Distinct A
Here in the report, Sort by column 1 asc.
You will get desired result.
MArk if Correct/Helps