1 Reply Latest reply on Sep 9, 2015 2:43 PM by Gianni Ceresa

    Grand Total based on Row

    user5388961
    user5388961 Sep 9, 2015 2:08 PM

      Hi guys,

       

      I require a bit favor from you regarding obiee 11g functionality. I have a report which should have grand totals based on rows.

      If i have only one row, i shouldn't seen the totals, other side, if i have more than one row, then i should see the Grand totals of the report.

       

      Please share your thoughts how we fulfil this. thanks.

       

      C................

      • 133 Views
      • Tags:
        • 1. Re: Grand Total based on Row
          Gianni Ceresa
          Gianni Ceresa Sep 9, 2015 2:43 PM (in response to user5388961)

          Hi,

          How? You simple don't ....

          In OBIEE grand totals are simple: always there or never there, so you can't say to be on screen only if more than one row.

          If you really want that you must calculate totals by yourself and not use the embedded functionality in table views (or pivot views).

          1 person found this helpful