- Article Type: Q&A
- Product: Alma
- Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care
Creating an analysis with Columns and Measures, and trying to show total row, it is only possible to select the total as "After". It means that the total row is always displayed at the bottom of the table.
How can the total displayed at the top of the table?
The customer advises:
I found an article in the Internet about grouping data in order to display grand total at the top of the table. The article says that OBIEE 11g does not have an option to show Grand Total "Before" values like it does in Pivot-table view.
So instead of grouping data, I changed the table view to pivot table view, and I had the choice of placing the grand total to the top or the bottom. Choosing the top it was possible to place the grand total to the top, which is exactly what was needed.
This can be seen with two screentakes: http://screencast.com/t/HYa2eDVKRdWS
See also solution in KCS # 000038744, "Analytics - display total number of rows in a report".