1 Reply Latest reply: Jul 18, 2013 1:25 PM by Sasi Nagireddy RSS

    OBIEE 11g Subtotals use Max aggregation and Grandtotal use Sum aggregation

    ChanM76

      Hi,

       

      Please let me know if the below requirement is possible in OBIEE 11g and if so how do we achieve it

      The subtotals apply the max( Facility Limit ) and the Grandtotals should apply the sum of the sub totals.

       

       


       

      Customer


       

       

      Facility No


       

       

      Facility Limit


       

       

      Morgan NY


       

       

      3456


       

       

      4000


       

       

      Morgan London


       

       

      3456


       

       

      5000


       

       

      Morgan Singapore


       

       

      3456


       

       

      75,000


       

       

      Subtotal


       

       

       


       

       

      75,000


       

       

       


       

       

       


       

       

       


       

       

      Deustche Bank NY


       

       

      5689


       

       

      6800


       

       

      Deustche Bank london


       

       

      5689


       

       

      45,000


       

       

      Deustche Bank Singapore


       

       

      5689


       

       

      95,000


       

       

      Subtotal


       

       

       


       

       

      95,000


       

       

       


       

       

       


       

       

       


       

       

      Grandtotal


       

       

       


       

       

      170,000