Add grand total to 'before values' in Analytics
When creating large data sets, it'd be useful to be able to right click at the top of a column, 'Show Row level Grand Total', and choose something to show at the TOP of a column, instead of having to choose 'After values'. This might help avoid having to use prompts or exporting just to count things.
-
As commented previously, using a pivot table is the right approach. https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/Analytics_-_Total_(sum)_at_Top_of_Table
-
Pauline Smith commented
To show the grand total at the top of the table, you can change the table into a Pivot table (icon at top: New View > Pivot table). The pivot table will be added after the original table. Delete the original table. Go to editing the pivot table to put the columns where you want. After clicking done with editing, point your cursor to the column header you want to get the grand total, right click, click on Show row level grand totals. Here you can choose before Values, or After Values. Choosing before Values will put the grand total at the top of the table.