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.
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