There is no way to create more complex queries on SmartBox SmartObject Data. To perform summation, max/min, etc, one has to create a hidden list and perform these queries on that using a function, not very performant. Or go through the oData layer which is a complex thing for a CitDev.

If one could add a function/aggregate on a SmartObject itself and then use that in a view, it would add a lot of business centric information without needing the complexities and overhead of a hidden list view.