🚀 go-pugleaf

Would be obliged if someone could let me know on how to perform
aggregate functions on a given rowset.   

Say, for example, you have a SQL table containing data on name of
students, Place of birth (like a given state in the US) and their text
score.  Suppose you want to know what is the average score for students
born in Kansas.  In your applicatin, you would normally carry out a
filter with the help of the data button components provided by VDB7
which are very good.  Now, you have a subset of your original rowset or
a sub-rowset.  What is OODML function or command for doing sum, average,
etc.?

I have tried the "calculate aggregates" function in VDB7 and it always
returns the result for the whole rowset and not a subset.  Could someone
shed some light on this?

Thank you in advance.