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

    How do I create a Pivot Table in Alma Analytics?

    • Product: Alma



    I would like to transpose certain rows in my Alma Analytics report into columns. How can I do this in OBI?


    1. Edit your report and go to the "Results" tab.

    2. Click the "New View" icon in the bottom left corner and select "Pivot Table"

    New View Pivot Table.jpg

    3. If the Pivot Table does not open for editing automatically, select "Pivot Table" in the "Views" section, then click the pencil icon to edit it.

    edit pivot table.jpg

    4. Within the "Layout" section, drag and drop the field(s) you would like to transpose from the "Rows" box to the "Columns" box. Move other fields as desired.

    drag and drop crop.jpg

    5. If you move a text-based field to the "Measures" box, the preview report may not show any values in any of the cells. To fix this, click "More Options..." for the field in the "Measures" box and select "Aggregation Rule > Max".

    more options aggregation.jpg

    6. When you are finished adjusting the Pivot Table, click the "Done" button.

    done butt arrow.jpg

    7. To remove the original table from the main view, select "Table" from the "Views" section and click "Remove View from Analysis".

    remove table.jpg

    7. To add the Pivot Table to the view, select "Pivot Table" from the "Views" section and click "Add View".

    add pivot.jpg


    Your completed Pivot Table should now appear in the main view.

    finished table.jpg

    Additional Information

    Instructions from Oracle are available here:



    • Article last edited: 24-Jul-2018
    • Was this article helpful?