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.
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).