Skip to main content
Ex Libris Knowledge Center

Analytics - Total (sum) at Top of Table

  • Article Type: Q&A
  • Product: Alma
  • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

Question

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?

Answer

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

Additional Information

See also solution in KCS # 000038744, "Analytics - display total number of rows in a report".

Category: Analytics

Subject: Reports