Is it possible to not display the TOTAL row in the datagrid view?
If we look at the example on the Perspective homepage, there is a "TOTAL" row for aggregates:
Is there a way to not display this row?
Not currently, but the data engine supports an undocumented leaves_only parameter for pivots that only output the leaf rows which would be somewhat straightforward to implement in the UI. In code, you can use this parameter directly to pivot a dataset, then load the resulting view into your perspective-viewer.
I'm going to go ahead and use this Issue to track this feature.
Tagging @franher because he mentioned that he was looking to contribute, and I think this would be an awesome contribution. Maybe all we need is an implementation of @texodus 's recommendation above added to the examples?
You can do something like this https://github.com/perspective-community/perspective-viewer-datagrid-norollups
Note that this does not use leaves_only, it somewhat inefficiently just blanks out the rows after