1 Reply Latest reply: Jan 12, 2013 4:51 AM by fiaz0419 RSS

    custom subtotal

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