Hi,
Could you help out with this issue. I'm building a OBIEE Answers Analysis. What I'm looking for are just the grand totals, and none of the details. Imagine there's a query for regions, salesperson, quarter, and revenue. The region and quarter will be filtered by a dashboard prompt selected by the end user. I'm only interested in seeing the grand total of revenue. In other words, the end user selects region and quarter, and I will display only the grand total of revenue.
Right now I see a list of salesperson, region, quarter and individual revenue, with the grand total revenue at the bottom of the table. What I would like to see is only the grand total and none of the details such as region, quarter, etc)
Can this be done?
Thanks,
Note: 11g / 11.1.1.7.x