2 Replies Latest reply: Mar 21, 2013 1:22 AM by BIDev RSS

    How to aggregate the measue based on different dimensions when click '∑'

    BIDev
      Hi Experts

      In OBIEE 11G, How to aggregate the measue based on different dimensions when click the '∑' in table or piovt view? OR Is there any better method for implemeting this functionality? Thanks.

      For example:
      Region---------Month--------Sales
      North----------201301-------1000
      North----------201302-------2000
      ------------------MTotal--------2000(LAST)
      NTotal--------------------------3000(SUM)
      South----------201301-------1000
      South----------201302-------4000
      ------------------Total----------4000(LAST)
      STotal--------------------------5000(SUM)