Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Analytics - Total (sum) at Top of Table

    • 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

    OBIEE 11g does not have an option to show Grand Total "Before" values like it does in Pivot-table view.

    Instead of grouping data, change the table view to pivot table view. This allows choice to place grand total at top or bottom.

    Additional Information

    See also How do I display the total number of rows in an Analytics report?


    Article last edited: 13-Sep-2017