This discussion is archived
1 Reply Latest reply: Jan 12, 2013 2:51 AM by fiaz0419 RSS

custom subtotal

e_macmill Newbie
Currently Being Moderated
Hello GURUs

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.

Example:

Database:

Company,A,B
MSTF,10000,50
MSTF,10000,10
MSTF,10000,40

How I need it in Report

Company,Limit
MSTF,50
MSTF,10
MSTF,40
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.

THANKS
  • 1. Re: custom subtotal
    fiaz0419 Journeyer
    Currently Being Moderated
    HI....

    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
    fiaz

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points