0 Replies Latest reply: Feb 12, 2013 6:36 PM by user8744765 RSS

    Help with Grand Totals and Subtotals in obiee 11g

    user8744765
      Hi Gurus,

      is there any option to show Grand total like in the example below - this is a union request (OPS will be same for all cutomers in one country)

      Area Country customer QTD OPS
      A Taiwan A 10 20
      A Taiwan B 15 20
      A Taiwan C 7 20
      A Taiwan D 25 20

      Taiwan Total                                           57                           20


      B Australia A 5 30
      B Australia b 10 30
      B Australia c 3 30
      B Australia d 2 30
      Australia Total                                            20                          30
      Grand Total                                             77                             50

      I tried doing max(ops by Country ) at criteria and Aggregation as sum but it is summiin for sub total and showing taiwan total as 80 and australia total as 120 .


      Your help will be greatly appreciated.

      Thanks a lot.